Free DP-500 Sample Questions — Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

You have a Power BI report hosted on the Power BI service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month. You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

• A. Create a mobile report that contains a column chart
• B. Add a column chart a bookmark, and a button for users to choose a visual
• C. Enable report readers to personalize visuals
• D. Create a separate report page for users to view a column chart

You have an Azure Synapse Analytics dedicated SQL pool and a Microsoft Purview account. The Microsoft Purview account has been granted sufficient permissions to the dedicated SQL pool. You need to ensure that the SQL pool is scanned by Microsoft Purview. What should you do first?

• A. Create a data policy
• B. Search the data catalog
• C. Register a data source
• D. Create a data share connection

You have a Power BI Premium capacity. You need to increase the number of virtual cores associated to the capacity. Which role do you need?

• A. Power BI workspace admin
• B. capacity admin
• C. Power Platform admin
• D. Power BI admin

You have a kiosk that displays a Power BI report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Configure the data sources to use DirectQuery
• B. Select Auto page refresh
• C. Enable Power BI embedded
• D. Enable the XMLA endpoint
• E. Add a Microsoft Power Automate visual to the report page
• F. Configure the data sources to use a streaming dataset

You have a Power BI tenant. You plan to publish 10 paginated reports that will be used by a team of business analysts. You need to create a new workspace for the reports. The solution must minimize costs. Which license mode should you select for the new workspace?

• A. Pro
• B. Premium per user
• C. Embedded
• D. Premium per capacity

You have a development workspace in the Power BI service. You plan to use Tabular Editor to develop and deploy a new dataset, and then use Power BI Desktop to create and publish a report to the Power BI service. Which three components should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. the Read Write XMLA endpoint in a capacity
• B. a Premium Per User workspace
• C. the Read Write XMLA endpoint in the tenant
• D. a .pbix file that has an imported dataset
• E. a .pbix file that has a live connection

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?

• A. Seaborn and TensorFlow
• B. Seaborn only
• C. Matplotlib and Seaborn
• D. Matplotlib only
• E. Matplotlib and TensorFlow
• F. TensorFlow only

You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model. You change a fact table named Table1 into a hybrid table. What else occurred on DM1 automatically after the change?

• A. Table1 was removed from the scheduled refresh
• B. Dimension tables that relate to Table1 were changed to dual storage mode
• C. related aggregation table was created
• D. DirectQuery partition was added to Table1

You have a 2-GB Power BI 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 service principal authentication for read-only admin APIs
• B. Connect the target workspace to an Azure Data Lake Storage Gen2 account
• C. Turn on Large dataset storage format
• D. Enable XMLA read-write

You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that the SQL pool is scanned by Azure Purview. What should you do first?

• A. Create a data policy
• B. Create a data share connection
• C. Search the data catalog
• D. Register a data source

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 BI tenant
• D. The sensitivity level for the dataset is set to Highly Confidential
• E. Row-level security (RLS) is missing from the dataset

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

You need to save Power BI 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. Dataflows must exist already for any directly connected Power BI workspaces
• C. The storage account must be protected by using an Azure Firewall
• D. The storage account must be created in a separate Azure region from the Power BI tenant and workspaces
• E. The storage account must have hierarchical namespace enabled

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. CSV
• B. Delta
• C. JSON
• D. Apache Parquet

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 BI Admin center, set Allow live connections to Enabled
• C. From the Power BI Admin center, set Allow service principals to use read-only Power BI admin APIs to Enabled
• D. From the Azure Active Directory admin center, create a security group
• E. From the Power BI Admin center, set Share content with external users to Enabled

You have an Azure Synapse Analytics workspace that is connected to a data lake. You train an Open Neural Network Exchange (ONNX) model named Model1. You need to implement Model1. What should you do first?

• A. Score Model1 by using OPENJSON()
• B. Load Model1 into a binary variable
• C. Load Model1 into a character variable
• D. Score Model1 by using PREDICT()

You have a Power BI 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. the layer order
• C. alt text
• D. the tab order

You are implementing a reporting solution that has the following requirements: Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics. Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB. Which storage mode provides the best response time for each group of users?

• A. Import for the external customers and DirectQuery for the security team
• B. DirectQuery for the external customers and import for the security team
• C. DirectQuery for the external customers and DirectQuery for the security team
• D. Import for the external customers and import for the security team

You have a PostgreSQL database named db1. You have a group of data analysts that will create Power BI datasets. Each analyst will use data from a different schema in db1. You need to simplify the process for the analysts to initially connect to db1 when using Power BI Desktop. Which type of file should you use?

• A. PBIT
• B. PBIX
• C. PBIDS

You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?

• A. organizational account
• B. Basic
• C. Web API
• D. Anonymous