Free Preparation Discussions
MENU
Microsoft DP-500 Exam
- Topic 1: Perform impact analysis of downstream dependencies from dataflows and datasets/ Manage Power BI assets by using Azure Purview
- Topic 2: Create queries, functions, and parameters by using the Power Query Advanced Editor/ Identify and implement performance improvements in queries and report visuals
- Topic 3: Identify requirements for a solution, including features, performance, and licensing strategy/ Recommend and configure an on-premises gateway in Power BI
- Topic 4: Identify data loading performance bottlenecks in Power Query or data sources/ Integrate an existing Power BI workspace into Azure Synapse Analytics
- Topic 5: Explore and visualize data by using the Azure Synapse SQL results pane/ Deploy and manage datasets by using the XMLA endpoint
- Topic 6: Integrate an analytics platform into an existing IT infrastructure/ Create and distribute paginated reports in Power BI Report Builder
- Topic 7: Recommend appropriate file types for querying serverless SQL pools/ Commit code and artifacts to a source control repository in Azure Synapse Analytics
- Topic 8: Design and configure Power BI reports for accessibility/ Implement performance improvements in Power Query and data sources
- Topic 9: Design and implement enterprise-scale row-level security and object-level security/ Analyze data model efficiency by using VertiPaq Analyzer
- Topic 10: Query advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models/ Connect to and query datasets by using the XMLA endpoint
- Topic 11: Identify an appropriate Azure Synapse pool when analyzing data/ Design and build composite models, including aggregations
- Topic 12: Explore data by using native visuals in Spark notebooks/ Explore data by using Azure Synapse Analytics
Free Microsoft DP-500 Exam Actual Questions
The questions for DP-500 were last updated On Apr. 29, 2024
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 se might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.
You discover that the model fails to process a source time field.
You need to ensure that the model processes the field.
Solution: You add a Power Query step to convert the time column into an integer column that represents the number of minutes.
Does this meet the requirement?
You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl tenant and Sub1 are linked to a single Azure AD tenant.
In Sub1, you create a storage account named storage1.
You need to configure a Power Bl workspace to store dataflows in storage1. The solution must use the principle of least privilege.
Which three roles should you assign for storage1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Azure Synapse Analytics notebook.
You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.
display (df1, summary = true)
Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl tenant and Sub1 are linked to a single Azure AD tenant.
In Sub1, you create a storage account named storage1.
You need to configure a Power Bl workspace to store dataflows in storage1. The solution must use the principle of least privilege.
Which three roles should you assign for storage1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have a Power Bl workspace named workspace1 that contains three reports and two dataflows.
You have an Azure Data Lake Storage account named storage1.
You need to integrate workspace1 and storage1.
What should you do first?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!