Online Access Free DP-500 Exam Questions

You have a Power Bl report that contains a bar chart. The bar chart displays sales by country.
You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader.
What should you configure on the bar chart?

• A.conditional formatting
• B.alt text
• C.the layer order
• D.the tab order

You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?

• A.a dedicated SQL pool
• B.a serverless SQL pool
• C.a Data Explorer pool
• D.an Apache Spark pool

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.
You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.
In which file format should you recommend storing the table data?

• A.Apache Parquet
• B.CSV
• C.JSON
• D.Delta

You have an Azure Synapse Analytics workspace that contains an Apache Spark pool. You create a notebook and configure a cell that runs the following SparkSQL query.
SELECT ProductID, ProductName, Category From products.
You need to create a column chart by using the built-in charting capability. The solution must visualize the distribution of product IDs across product categories.

Correct Answer:

You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.
* New reports can be embedded only in locations that require authentication.
* Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.From Capacity settings, set XMLA Endpoint to Read Write.
• B.From Embed Codes, delete all the codes.
• C.From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
• D.From Tenant settings, set Publish to web to Disable.
• E.From the Premium per user settings, set XMLA Endpoint to Off.