PL-300 V3

HOTSPOT 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...

What is the minimum number of datasets and storage modes required to support the reports?A . two imported datasets B. a single DirectQuery dataset C. two DirectQuery datasets D. a single imported datasetView AnswerAnswer: D Explanation: "The analysts responsible for each business unit must see all the data the board...

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?A . bar chart B. scatterplot C. pie chartView AnswerAnswer: A Explanation: Scenario: The On-Time Shipping report will show the following metrics for...

CORRECT TEXT You have a Power 31 data model that contains a table named Stores. The table has the following columns: * Store Name * Open Date * Status * State * City You need to create a calculated column named Active Store Name that meets the following requirements: View...

You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit. Which type of visual should you use?A . Q&A B. decomposition tree C. smart narrative D. key influencersView AnswerAnswer: B

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit. You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model. What should you do?A . Add...

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: ✑ Customer ID ✑ Customer Name ✑ Phone ✑ Email Address ✑ Address ID Address contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City...

HOTSPOT 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. View AnswerAnswer: Explanation: Graphical user interface, text, application, email Description automatically generated

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?A . Apply row-level security (RLS) to the Region table based on the sales manager username. B. Configure a bi-directional relationship between...

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...