DP-500 V4

DRAG DROP You are using DAX Studio to query an XMLA endpoint. How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view...

You have the following Python code in an Apache Spark notebook. Which type of chart will the code produce?A . a stacked bar chartB . a pie chartC . a bar chartD . an area chartView AnswerAnswer: D Explanation: The matplotlib.pyplot.fill_between function fills the area between two horizontal curves. The...

DRAG DROP You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the...

HOTSPOT You are configuring an aggregation table as shown in the following exhibit. The detail table is named FactSales and the aggregation table is named FactSales(Agg). You need to aggregate SalesAmount for each store. Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate...

You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users. What should you in the recommendation?A . Update the statistics for the serverless SQL pool.B . Move the data from the serverless SQL pool to a...

You need to recommend a solution for the analysts in the Finance and Accounting business unit to mitigate the increase in maintenance of their assets in the Power Bl tenant. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth...

You have a Power Bl data model. You need to refresh the data from the source every 15 minutes. What should you do first?A . Enable the XMLA endpoint.B . Define an incremental refresh policy.C . Change the storage mode of the dataset.D . Configure a scheduled refresh.View AnswerAnswer: D...

Topic 2, Contoso, Ltd Overview Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers. Contoso has a main office in Los Angeles and two branch offices in New York and Seattle. Data Infrastructure Contoso has a 50-TB data warehouse that uses an instance...

You need to recommend a solution for the customer workspaces to support the planned changes. Which two configurations should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Set Use datasets across workspaces to EnabledB . Publish...

You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl users. The customer identifies the following requirements: • Ensure that all the users can create paginated reports. • Ensure that the users can create reports containing Al visuals. • Provide autoscaling of the...