Microsoft Microsoft Certified: Azure Enterprise Data Analyst Associate DP-500 Questions & Answers

• Question 41:

  You have a Power BI dataset that has only the necessary fields visible for report development. You need to ensure that only 25 fields are available when end users personalize visuals. What should you do?

  A. From Tabular Editor, create a new perspective.

  B. From Tabular Editor, create a new role.

  C. Hide all the fields in the dataset.

  D. Configure object-level security (OLS).

  Correct Answer: A

• Question 42:

  You have a Power BI dataflow named DF1 that contains the following columns:

  OrderID SaleDate ProductID SalesAmount ProductCategory

  You create a Power BI dataset named DS1 that uses DF1 as a data source. DS1 creates an aggregated view of the data in DF1. The view contains the following columns:

  SaleMonth SalesAmount ProductCategory

  You need to minimize how long it takes to refresh DS1.

  What should you do first?

  A. Add a computed entity to DF1.

  B. Create a custom function in DS1.

  C. Create a linked entity in DF1.

  D. Add a computed column to DS1.

  Correct Answer: D

• Question 43:

  You have the following code in a cell in an Azure Synapse notebook.

  

  You need to replace the comment on the first line of the code with the correct magic command. Which magic command should you use?

  A. %%sparkr

  B. %%pyspark

  C. %%spark

  D. %%sql

  Correct Answer: B

• Question 44:

  You have a Power BI report that contains a single page. The page contains two line charts and one bar chart.

  You need to ensure that users can perform the following tasks for all three visuals:

  Switch the measures used in the visuals.

  Change the visual type.

  Add a legend.

  The solution must minimize development effort.

  What should you do?

  A. Enable personalization for each visual.

  B. Enable personalization for the report.

  C. Create a bookmark for each acceptable combination of visual type, measure, and legend in the bar chart.

  D. Edit the interactions between the three visuals.

  Correct Answer: B

• Question 45:

  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. Yes

  B. No

  Correct Answer: B

• Question 46:

  You have an Apache Spark notebook that contains PySpark code and is used to explore data in an Azure Synapse Analytics workspace.

  You need to create data visualizations in the notebook by using built-in libraries.

  Which two libraries can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Gleam

  B. Plotly

  C. Seaborn

  D. Matplotlib

  Correct Answer: CD

  https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization-tutorial#visualize-data

• Question 47:

  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. The workspace is in shared capacity.

  B. You have insufficient permissions.

  C. Dataset certification is disabled for the Power Bl tenant.

  D. The sensitivity level for the dataset is set to Highly Confidential.

  E. Row-level security (RLS) is missing from the dataset.

  Correct Answer: BC

  Explanation: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service- endorsement-overview Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-setup- certification https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content

• Question 48:

  You have a sales report as shown in the following exhibit.

  

  The sales report has the following characteristics:

  The measures are optimized.

  The dataset uses import storage mode.

  Data points, hierarchies, and fields cannot be removed or filtered from the report page.

  From powerbi.com, users experience slow load times when viewing the report.

  You need to reduce how long it takes for the report to load without affecting the data displayed in the report.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Change the report theme to monochromatic.

  B. Replace the single-value cards with a multi-row card.

  C. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.

  D. Replace all the filters on the Filters pane with visual slicers on the report page.

  Correct Answer: BC

• Question 49:

  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. displayHTML()

  B. display(df, summary=true)

  C. %%configure

  D. display(df)

  E. %%lsmagic

  Correct Answer: B

  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.

  Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark- data- visualization

• Question 50:

  You have a Power BI tenant.

  You plan to register the tenant in an Azure Purview account.

  You need to ensure that you can scan the tenant by using Azure Purview.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. From the Microsoft 365 admin center, create a Microsoft 365 group.

  B. From the Power Bl Admin center, set Allow live connections to Enabled.

  C. From the Power Bl Admin center, set Allow service principals to use read-only Power Bl admin APIs to Enabled.

  D. From the Azure Active Directory admin center, create a security group.

  E. From the Power Bl Admin center, set Share content with external users to Enabled.

  Correct Answer: CD

  Scan same-tenant Power BI using Azure IR and Managed Identity in public network. Make sure Power BI and Microsoft Purview accounts are in the same tenant. Make sure Power BI tenant Id is entered correctly during the registration. From Azure portal, validate if Microsoft Purview account Network is set to public access. From Power BI tenant Admin Portal, make sure Power BI tenant is configured to allow public network.

  (D) In Azure Active Directory tenant, create a security group. From Azure Active Directory tenant, make sure Microsoft Purview account MSI is member of the new security group. On the Power BI Tenant Admin portal, validate if Allow service principals to use read-only Power BI admin APIs is enabled for the new security group.

  Associate the security group with Power BI tenant Log into the Power BI admin portal.

  Select the Tenant settings page.

  (C) Select Admin API settings > Allow service principals to use read-only Power BI admin APIs (Preview).

  Select Specific security groups.

  Select Admin API settings > Enhance admin APIs responses with detailed metadata > Enable the toggle to allow Microsoft Purview Data Map automatically discover the detailed metadata of Power BI datasets as part of its scans.

  Reference: https://docs.microsoft.com/en-us/azure/purview/register-scan-power-bi-tenant