Question 146
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
Question 147
Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
You need to shape the query to display the following three columns:
* Month
* Sales
* Year
'What should you select in Power Query Editor?
You need to shape the query to display the following three columns:
* Month
* Sales
* Year
'What should you select in Power Query Editor?
Question 148
In Power BI Desktop, you are creating a report that will contain three pages.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
Question 149
You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct
Question 150
You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table .
Which type of visualization should you use?
You need to identify outliers in the table .
Which type of visualization should you use?