👉Get Full PDF
| Question 61 You are using Power Query Editor in Power BI Desktop to import an Excel file that contains only one worksheet. The data in the file starts with column names on row 5 of the worksheet. There are occasional blank values in column A of the worksheet. You need to remove the blank rows at the top of the worksheet and use the 5th row as the column headers of the table. What should you do first? A. Remove empty values from the first column. B. Remove the top 4 rows. C. Use the current headers as the first row. D. Use the first row as headers. |
61. Click here to View Answer
Answer : (B) Remove the top 4 rows.
| Question 62 You preview a query from the Power Query Editor. You notice that Column A contains blank values and null values. You need to convert all blank values to null. Which option should you select from Column A? A. Clean B. Fill Down C. Replace Errors D. Replace Values |
62. Click here to View Answer
Answer is (D) Replace Values
| Question 63 What type of relationship is automatically created when you load tables with matching column names into Power BI? A. One-to-many, inactive B. One-to-many, active C. Many-to-many D. One-to-one |
63. Click here to View Answer
Answer : (B) One-to-many, active
| Question.64 The two types of tables in a star schema are what? A. Active and inactive tables B. Qualitative and quantitative data tables C. Fact and dimension tables |
64. Click here to View Answer
Answer is (C) Fact and dimension tables
| Question.65 What is the difference between a fact table and a dimension table? A. Fact tables store observations or events while dimension tables contain information about specific entities within the data B. Fact tables contain information about specific entities while dimension tables contain information about observational data C. Dimension tables tell you about specific roles in Power BI while fact tables tell you information about facts that are associated with those roles in Power BI D. There is no difference |
65. Click here to View Answer
Answer is (A) Fact tables store observations or events while dimension tables contain information about specific entities within the data