Get Prepared for Your DP-500 Exam With Actual 115 Questions
Valid DP-500 Test Answers Full-length Practice Certification Exams
Microsoft DP-500 exam is designed to test the knowledge and skills of professionals who are responsible for designing and implementing enterprise-scale analytics solutions using Microsoft Azure and Microsoft Power BI. DP-500 exam is intended for individuals who have experience with data analysis, data modeling, and data visualization, as well as those who work with data engineers, data analysts, and business intelligence professionals.
NEW QUESTION # 58
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 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 open row set 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 an external table for the Parquet files and updating the query to use the table Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 59
You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.
You need to review statistics for a DataFrame that includes:
The column name
The column type
The number of distinct values
Whether the column has missing values
Which function should you use?
- A. %%lsmagic
- B. displayHTML()
- C. display(df)
- D. %%configure
- E. display(df, summary=true)
Answer: E
Explanation:
display(df) statistic details
You can use display(df, summary = true) to check the statistics summary of a given Apache Spark DataFrame that include the column name, column type, unique values, and missing values for each column. You can also select on specific column to see its minimum value, maximum value, mean value and standard deviation.
NEW QUESTION # 60
You have an Azure Synapse notebook.
You need to create the visual shown in the following exhibit.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle
NEW QUESTION # 61
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 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 open row set 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 using openrowset with to explicitly specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 62
You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake Storage Gen2 account and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?
- A. OPCNROWSET
- B. OPEMDATASOURCE
- C. OPENOUERY
- D. STRIMO_SPLIT
Answer: A
NEW QUESTION # 63
You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.
Multiple reports use the dataset.
A database administrator reports that too many queries are being sent from Power Bl to the database.
You need to reduce the number of queries sent to the database. The solution must meet the following requirements:
* DirectQuery must continue to be used.
* Visual interactions in all the reports must remain as they are configured currently.
* Consumers of the reports must only be allowed to apply filters from the Filter pane.
Which two settings should you select? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Add a single Apply button to the filter pane to apply changes at once
- B. Add an Apply button to each slicer to apply changes when you're ready
- C. Disabling cross highlighting/filtering by default
- D. Add Apply buttons to all basic filters to apply changes when you're ready
- E. Ignore the Privacy Levels and potentially improve performance
Answer: A,B
Explanation:
Reduce queries
Reduce the number of queries sent by Power BI using the Query reduction settings. For slicers, select the "Add an Apply button to each slicer to apply changes when you're ready" option. For filters, select "Add a single Apply button to the filter pane to apply changes at once (preview)."
NEW QUESTION # 64
You open a Power Bl Desktop report that contains an imported data model and a single report page.
You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces
the results shown in the following exhibit
What can you identify from the results?
- A. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
- B. The Actual/Forecast Billable Hrs YTD visual displays the most data.
- C. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
- D. Unoptimized DAX queries cause the page to load slowly.
Answer: A
NEW QUESTION # 65
What should you configure in the deployment pipeline?
- A. a backward deployment
- B. auto-binding
- C. a data source rule
- D. a selective deployment
Answer: B
NEW QUESTION # 66
You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account.
You need to query all the files in the 'csv/taxi/' folder and all its subfolders. All the files are in CSV format and have a header row.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 67
You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Row-level security (RLS) is missing from the dataset.
- B. The workspace is in shared capacity.
- C. The sensitivity level for the dataset is set to Highly Confidential.
- D. You have insufficient permissions.
- E. Dataset certification is disabled for the Power Bl tenant.
Answer: D,E
Explanation:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorsement-overview Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content
NEW QUESTION # 68
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
You need to present the data distribution statistics from a DataFrame in a tabular view.
Which method should you invoke on the DataFrame?
- A. corr
- B. freqlcems
- C. summary
- D. rollup
Answer: A
Explanation:
pandas.DataFrame.corr computes pairwise correlation of columns, excluding NA/null values.
Incorrect:
* freqItems
pyspark.sql.DataFrame.freqItems
Finding frequent items for columns, possibly with false positives. Using the frequent element count algorithm described in https://doi.org/10.1145/762471.762473, proposed by Karp, Schenker, and Papadimitriou.'
* summary is used for index.
* There is no panda method for rollup. Rollup would not be correct anyway.
NEW QUESTION # 69
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 Embed Codes, delete all the codes.
- B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
- C. From Capacity settings, set XMLA Endpoint to Read Write.
- D. From the Premium per user settings, set XMLA Endpoint to Off.
- E. From Tenant settings, set Publish to web to Disable.
Answer: B
NEW QUESTION # 70
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry dat a. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-selectrows
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-comparison-with-blob-storage
NEW QUESTION # 71
You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.
Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://www.royalcyber.com/blog/data-services/dedicated-sql-pool-vs-serverless-sql/
NEW QUESTION # 72
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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.
Answer:
Explanation:
1 - Install the on-premises data gateway (standard mode)
2 - From powerbi.com, add a data source to the gateway clusters
3 - From powerbi.com, configure Dataset1 to use a data gateway.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
NEW QUESTION # 73
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. Some query steps are folding.
- B. All the query steps are folding.
- C. The query is timing out.
- D. Elevated permissions are being used to query records.
Answer: A
NEW QUESTION # 74
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?
- A. the query plan
- B. the query history
- C. the server timings
- D. the query statistics
Answer: A
Explanation:
Open DAX Studio.
Paste the query there, enable Query Plan display and Server Timings, run your query (with clear cache), and then study the query plan for large row counts. Once the culprit is identified you can decide how to rewrite your DAX to make that part faster.
Reference:
https://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf
Topic 1, Contoso, Ltd
Data Infrastructure
Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines.
The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access alt the data.
Contoso has one Power Bl workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool.
Users frequently query the Synapse Analytics workspace by using Transact-SQL.
User Problems
Contoso identifies the following user issues:
* Some users indicate that the visuals in Power Bl reports are slow to render when making filter selections.
* Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.
* Users indicate that the data in Power Bl reports is stale. You discover that the refresh process of the Power Bl model occasionally times out Planned Changes Contoso plans to implement the following changes:
* Into the existing Power Bl dataset, integrate an external data source that is accessible by using the REST API.
* Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
* Provide all the customers with their own Power Bl workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
* Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
* Deploy prebuilt datasets to Power Bl to simplify the query experience of the customers.
* Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.
NEW QUESTION # 75
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 76
You have a 2-GB Power Bl dataset.
You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize
how long it will take to apply changes to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. Enable XMLA read-write.
- B. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
- C. Enable service principal authentication for read-only admin APIs.
- D. Turn on Large dataset storage format.
Answer: A
NEW QUESTION # 77
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 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 Bl dataset named Datasetl.
In Dataset1, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 78
You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
- A. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
- B. The storage account must be protected by using an Azure Firewall.
- C. Dataflows must exist already for any directly connected Power Bl workspaces.
- D. The storage account must have hierarchical namespace enabled.
- E. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
Answer: A,D
NEW QUESTION # 79
You have the following code in an Azure Synapse notebook.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://matplotlib.org/stable/gallery/lines_bars_and_markers/bar_stacked.html
https://matplotlib.org/stable/api/legend_api.html
NEW QUESTION # 80
......
To pass the Microsoft DP-500 exam, candidates need to have a deep understanding of various data storage and processing technologies such as Azure Synapse Analytics, Azure Data Lake Storage, and Azure Stream Analytics. Candidates also need to have a good grasp of data visualization technologies such as Power BI and its various features for creating and publishing reports and dashboards. DP-500 exam also tests the candidate's ability to design and implement security and compliance solutions for their data solutions.
Accurate & Verified 2023 New DP-500 Answers As Experienced in the Actual Test!: https://guidetorrent.passcollection.com/DP-500-valid-vce-dumps.html
