👉Get Full PDF
| Question 81 If you import or create your own date table, which of these requirements must it meet? A. Must contain all the days for all years represented in the model B. Cannot contain duplicate dates C. Must have at least one field set as a Date or DateTime datatype D. All of the above |
81. Click here to View Answer
Answer is (D) All of the above
To import or create your own date table, it must meet all 3 of these requirements, and all times must be identical (i.e. 12:00).
| Question 82 You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables: – Product (Product_id, Product_Name) – Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) – Salesperson (Salesperson_id, Salesperson_name, address) The model has the following relationships: – Sales to Product – Sales to Salesperson You create a new Power BI file and import the Power Pivot model. You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report? A. Create a one-to-one relationship between Product and Salesperson. B. For each relationship, change the Cross filter direction to Both. C. For each relationship, change the Cardinality to One to one (1:1). D. Change a many-to-one relationship between Product and Salesperson. |
82. Click here to View Answer
Answer is (B) For each relationship, change the Cross filter direction to Both.
Their’s no need to create another relationship, the model already has one that extends to the needed level. You know only need to allow the Sales table to filter Product an you can do that by changing the cross filter to both.
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
| Question 83 You have two tables named CustomerVisits and Date in a Power BI model. You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit.  You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August. You need to fix the report to display the correct data for each month. What should you do? A. Modify the measure to use the CALCULATE DAX function. B. Create a relationship between the CustomerVisits table and the Date table. C. Modify the measure to use the sum DAX function. D. Create a hierarchy in the Date table. |
83. Click here to View Answer
Answer is (B) Create a relationship between the CustomerVisits table and the Date table.
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures
| Question 84 You have a query that retrieves sales data. A sample of the data is shown in the following table.  You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row. What should you click on the Transform tab in Query Editor? A. Format, and then Clean B. Date, and then Earliest C. Fill, and then Down D. Replace Values, and then Replace Errors |
84. Click here to View Answer
Answer is (C) Fill, and then Down
Under Fill in the Transform ribbon, you DOWN (for replacing null values with preceding values, and UP (replaces null values with values after them).
References:
https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/
| Question 85 You have a table named Sales. A sample of the data in Sales is shown in the following table.  You create a stacked column chart visualization that displays ProductName by Date. You discover that the axis for the visualization displays all the individual dates. You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day. What should you do first? A. Create a new table that has columns for the date, year, week, and day. B. Create a new hierarchy in the Sales table. C. Format the visualization and set the type of the X-Axis to Categorical. D. Configure a visual filter for the Date column that uses an advanced filter. |
85. Click here to View Answer
Answer is (A) Create a new table that has columns for the date, year, week, and day.
1. create a Date table, including columns: date, week, month, quarter, year.
2. and then create relationship between table “date” and fact table “Sales via [Date].
3. hierarchy: Y/M/W/D