PL-300 V7

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?A . scatter chartB . ribbon chartC...

HOTSPOT You have an API that returns more than 100 columns. The following is a sample of column names. ✑ client_notified_timestamp ✑ client_notified_source ✑ client_notified_sourceid ✑ client_notified_value ✑ client_responded_timestamp ✑ client_responded_source ✑ client_responded_sourceid ✑ client_responded_value You plan to include only a subset of the returned columns. You need to remove...

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'A . import that uses a Microsoft accountB . DirectQuery that uses the end-user s credentialsC . DirectQuery that uses a database credentialD . Import that uses a database credentialView AnswerAnswer: B

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?A . Key influencesB . Funnel chartC . Q&AD . Line and clustered...

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number...

HOTSPOT 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. View AnswerAnswer: Explanation: Box 1: CALCULATE CALCULATE evaluates an expression...

HOTSPOT 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: View AnswerAnswer:

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?A . =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text...