1-99 of 99
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL Server table named Order that has more than 100 million records. During the development
process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function. Does this meet the goal?
A. Yes
B. No
Give this one a try later!
, B (No; The filter is applied after the data is imported.)
Why would you want to override the default context?
A. To create measures that behave according to your intentions, regardless of what the user
selects.
B. To create measures that do not summarize or average.
C. To create new relationships.
A (To create measures that behave according to your intentions, regardless of what the
user selects.)
You have a Power BI dashboard that monitors the quality of manufacturing processes. The
dashboard contains the following elements:
- A line chart that shows the number of defective products manufactured by day.
- A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds
3%. What should you create?
A. a Q&A visual
,B. a subscription
C. a smart narrative visual
D. an alert
D (an alert)
Which two functions will help you compare dates to the previous month?
A. CALCULATE and PREVIOUSMONTH
B. TOTALYTD and PREVIOUS MONTH
D. CALCULATE and TOTALTYD
A (CALCULATE and PREVIOUSMONTH)
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted
on other pages.
, You need to recommend a solution to ensure that users can select a value once to filter the results
on all the pages. What are two possible recommendations to achieve this goal?
A. Replace the slicers with report-level filters.
B. Sync the slicers across the pages.
C. Create a bookmark for each slicer value.
D. Replace the slicers with page-level filters.
E. Replace the slicers with visual-level filters.
A and B (Replace the slicers with report-level filters. And sync the slicers across the
pages.)
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL Server table named Order that has more than 100 million records. During the development
process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?
A. Yes
B. No
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL Server table named Order that has more than 100 million records. During the development
process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function. Does this meet the goal?
A. Yes
B. No
Give this one a try later!
, B (No; The filter is applied after the data is imported.)
Why would you want to override the default context?
A. To create measures that behave according to your intentions, regardless of what the user
selects.
B. To create measures that do not summarize or average.
C. To create new relationships.
A (To create measures that behave according to your intentions, regardless of what the
user selects.)
You have a Power BI dashboard that monitors the quality of manufacturing processes. The
dashboard contains the following elements:
- A line chart that shows the number of defective products manufactured by day.
- A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds
3%. What should you create?
A. a Q&A visual
,B. a subscription
C. a smart narrative visual
D. an alert
D (an alert)
Which two functions will help you compare dates to the previous month?
A. CALCULATE and PREVIOUSMONTH
B. TOTALYTD and PREVIOUS MONTH
D. CALCULATE and TOTALTYD
A (CALCULATE and PREVIOUSMONTH)
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted
on other pages.
, You need to recommend a solution to ensure that users can select a value once to filter the results
on all the pages. What are two possible recommendations to achieve this goal?
A. Replace the slicers with report-level filters.
B. Sync the slicers across the pages.
C. Create a bookmark for each slicer value.
D. Replace the slicers with page-level filters.
E. Replace the slicers with visual-level filters.
A and B (Replace the slicers with report-level filters. And sync the slicers across the
pages.)
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft
SQL Server table named Order that has more than 100 million records. During the development
process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?
A. Yes
B. No
