Free DP-500 Exam Braindumps (page: 17)

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 answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

The queries use OPENROWSET and infer the schema shown in the following table.



You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.

Does this meet the goal?

HOTSPOT (Drag and Drop is not supported)
You are creating a Power BI Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.

How should you complete the Python code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are configuring a Power BI report for accessibility as shown in the following table.




You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You use Azure Synapse Analytics and Apache Spark notebooks to explore native visuals.

You need to use PySpark to gain access to the visual libraries.

Which Python libraries should you use?