What should you configure?

HOTSPOT You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The Viewer role to the workspace The Viewer role gives a read-only...

September 13, 2021 No Comments READ MORE +

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals?

Topic 2, Contoso Ltd, Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time...

September 13, 2021 No Comments READ MORE +

What should you do before you can create the relationship?

You need to create the required relationship for the executive's visual . What should you do before you can create the relationship?A . Change the data type of Sales[region_id] to Whole Number.B . In the Sales table, add a measure for sum(sales_amount).C . Change the data type of sales[sales_id] to...

September 12, 2021 No Comments READ MORE +

Which type of calculation and which formula should you use?

HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table . Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer...

September 12, 2021 1 Comment READ MORE +

Which four actions should you perform in sequence?

DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...

September 12, 2021 No Comments READ MORE +

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Which DAX expression should you use to get the ending balances in the balance sheet reports?A . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )B . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )C . FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )D . CALCULATE (...

September 11, 2021 No Comments READ MORE +

What should you recommend?

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity.B . Create dataflows for the standardized data and make the dataflows available for...

September 11, 2021 No Comments READ MORE +

How should you complete the DAX expression?

HOTSPOT You have a Power BI report. You need to create a calculated table to return the 100 highest spending customers. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box...

September 11, 2021 No Comments READ MORE +

How should you complete the calculation?

DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total...

September 11, 2021 No Comments READ MORE +

What should you recommend?

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is...

September 10, 2021 No Comments READ MORE +