You build a report to analyze customer transactions from a database that contains the tables shown in the following table
You import the tables. Which relationship should you use to link the tables?
A. one-to-many from Transaction to Customer B. one-to-one between Customer and Transaction C. many-to-many between Customer and Transaction D. one-to-many from Customer to Transaction
HOTSPOT You create a Power BI dataset that contains the table shown in the following exhibit
You need to make the table available as an organizational data type in Microsoft Excel. How should you configure the properties of the table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
HOTSPOT You have a Power BI imported dataset that contains the data model shown in the following exhibit. C
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area
53.HOTSPOT You plan to create Power BI dataset to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL database. View1 contains the columns shown in the following table
View2 contains the columns shown in the following table
The views can be related based on the Class ID column. Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID. You need to design a star schema data model by using the data in both views.
The solution must facilitate the following analysis:
✑ The count of classes that occur by period
✑ The count of students in attendance by period by day
✑ The average number of students attending a class each month In which table should you include the Teacher First Name and Period Number fields?
To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do?
HOTSPOT You have a Power BI report. You have the following tables
You have the following DAX measure.
Accounts :=
CALCULATE (
DISTINCTCOUNT (Balances[AccountID]),
LASTDATE ('Date'[Date])
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
HOTSPOT You are creating a Microsoft Power BI data model that has the tables shown in the following table
The Products table is related to the ProductCategory table through the ProductCategoryID column. Each product has one product category. You need to ensure that you can analyze sales by product category. How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys. Solution: For each date foreign key, you add inactive relationships between the sales table and the date table. Does this meet the goal?
You need to support the analysis of sales over time based on all the date foreign keys. Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date. Does this meet the goal?
You need to support the analysis of sales over time based on all the date foreign keys. Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. Does this meet the goal?
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time. How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables. The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following: •One row per employee for each month the employee is employed •In each row, a date key that shows the first day of the month of each snapshot You have a related date table that contains dates for the years 2020 to 2030. You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month. How should you complete the measure? To answer, select the appropriate options in the answer area
Last changed2 hours ago
