Question 21
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Question 22
You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
Question 23
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.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 24
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 25
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2.
Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
The model contains two row-level security (RLS) roles named Role1 and Role2.
Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?