dumpstool logo
You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart
formatting.
What should you do?
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Vou plan to create a Power B1 report that will be connected to multiple data sources. One of the data sources contains law records. You need to ensure that other queries cannot access the tax record Information. To what should you set Privacy Level for the data source?
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 area. NOTE: Each correct selection is worth one point.
Which DAX expression should you use to get the ending balances in the balance sheet reports?
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
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?
You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?
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.
What is the minimum number of datasets and storage modes required to support the reports?
You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.
What should you set as the relationship cardinality?
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have a dataset that is used infrequently and refreshes every hour.
You receive a notification that the refresh was disabled due to inactivity.
Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You are building a Power Bl report that uses data from an Azure SQL database named erp1.
You Import the following tables.
You need to perform the following analyses:
• Orders sold over time that include a measure of the total order value
• Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
You have the line chart shown in the exhibit. (Click the Exhibit tab.)
You need to modify the chart to meet the following requirements:
Identify months that have order counts above the mean.
Display the mean monthly order count.
Which three 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 order.
In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.
What should you do?
You build a Power Bi report that displays loT temperature data streaming from a refrigerator.
You publish the report to the Power BI service.
You need to be notified when the temperature rises above four degrees Celsius.
What should you do?
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power Bl deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
You have a Fabric workspace named Workspace1 that contains two Power Bl reports named Report1 and Report2.
You create a workspace app that contains both reports.
You need to ensure that the app meets the following requirements:
• Report1 must be visible to all the users in your organization.
• Report2 must be visible to only a security group named Group1.
What should you do next?
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.
Which DAX formula should you use?
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?
You use Power Query Editor to review a query that contains a column named Country.
You need to view the following information in the Data preview view for the Country column:
• The percentage of values that contain errors.
• The count of empty values.
What should you enable? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Power B1 report. The report contains a line chart that displays sales data for several regions.
You need to add an element to the report that will enable users to filter the sales data to include only a selected region.
Which two elements achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:
• Sales invoices must be exported in a PDF format
• The PDF exports must show all columns and rows clearly.
What should you create?
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Which three 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 order.
You publish the semantic model to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
What should you create to meet the reporting requirements of the sales department?
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
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:
You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
You need to create a measure that will return the percentage of late orders.
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.
