DP-500 V1

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 have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset. During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB." You need to ensure that...

You have a Power Bl dataset that contains the following measure. You need to improve the performance of the measure without affecting the logic or the results. What should you do?A . Replace both calculate functions by using a variable that contains the calculate function. B. Remove the alternative result...

You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that the SQL pool is scanned by Azure Purview. What should you do first?A . Register a data source. B. Search the data catalog. C. Create a data share connection. D. Create a data policy.View AnswerAnswer: B

DRAG DROP You need to integrate the external data source to support the planned changes. 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. View AnswerAnswer:

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.) The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.) You need to reduce the model size by eliminating invalid relationships. Which column...

You have a file named File1.txt that has the following characteristics: • A header row • Tab delimited values • UNIX-style line endings You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool. Which query should you execute? A . Option A B. Option B C....

DRAG DROP You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate. You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year....

You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources: • A CSV file in an Azure Storage account • An Azure Database for PostgreSQL database You plan to use...

HOTSPOT You need to build a Transact-SQL query to implement the planned changes for the internal users. How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: PREDICT Provide internal...