DP-500 Exam Questions

Power BI supports R language for creating visuals. Which two statements from below are correct in this regard? (Choose two)

Hotspot Question You have an Azure Synapse notebook. You need to create the visual shown in the following exhibit (chart 1). How should you complete the code? To answer, select the...

Hotspot Question You are using an Azure Synapse notebook to create a Python visual. You run the following code cell to import a dataset named iris. `iris = sns.load_dataset("iris")...

Hotspot Question You use Veripaq Analyzer to analyze a model. The relationships tab contains the results shown in the following exhibit. Use the drop-down menus to select the answe...

You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate. You need to i...

You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of files and the number of rows in each file. How should you complete the Transact-SQL statement?...

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

You manage a dataset that contains the two data sources as shown in the following table. Data source Type of data Privacy level Azure SQL database Sensitive company data Private Mi...

You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time. You use Power BI Report Builder to create a...

You have a Power BI tenant that uses a primary domain named fabrikam.com and contains a Power BI Premium workspace named Workspace1. Workspace1 contains a dataset named DS1. DS1 is...

You are building a financial report by using Power BI. You have a table named financials that contains two columns named Date and Sales. You need to create a DAX measure that calcu...

You work for a company which sells mobile phones. The company has an Azure Synapse Analytics dataset that contains data related to the sales of this year's latest mobile phone. You...

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

You have a Power BI tenant. You invite an external consultant to work in the tenant. You need to grant the consultant access to the tenant. The solution must meet the following req...

You have a Power BI tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1. You create a paginated report that does NOT use row-level security (RLS)....

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

You have a Power BI tenant and an Azure subscription named Sub1. The Power BI tenant and Sub1 are linked to a single Azure AD tenant. In Sub1, you create a storage account named st...

You have a Power BI workspace named workspace1 that contains three reports and two dataflows. You have an Azure Data Lake Storage account named storage1. You need to integrate work...

You have an Azure Synapse Analytics notebook. You run the %%sql magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code. `display...

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

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

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

Hotspot Question You need to recommend a security solution for the Power BI tenant to control external data sharing. The solution must meet the technical requirements. What should...

The enterprise analytics team needs to create a view for the survey response data. The solution must meet the technical requirements. How should you complete the code? To answer, s...

You need to ensure that the new process for deploying reports and datasets to the User Experience workspace meets the technical requirements. Which three actions should you perform...

What should the team do first?

You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team. What should you do?

You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace. What should you do?

You need to recommend changes to the Power BI tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?

You deploy an 80-GB compressed data model to a Power BI Premium workspace. You discover that the model has the following issues: - The model recently increased excessively in size....

QUESTION 176 Hotspot Question You have a hybrid tenant in Microsoft Azure Active Directory (AD), part of Microsoft Entra, that syncs by using Azure AD Connect. You are building a d...

QUESTION 177 Hotspot Question You have a Power BI model that contains three tables named Sales, Marketing, and Delivery. The Sales table relates to the Marketing and Delivery table...

QUESTION 178 Hotspot Question You use Power Query Editor to transform data. You need to create a function named ConvertF2C that accepts a temperature value in Fahrenheit and return...

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

You have a deep neural network (DNN) machine learning model named Model1 and an Azure Synapse Analytics workspace named Workspace1. You need to score the data in Workspace1 by usin...

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

You have the following code in a cell in an Azure Synapse notebook. # insert command here new_rows = [('WA',2,45000), ('WA',35,65000),('WA',50,85000)] demo_df = spark.createDataFra...

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

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

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

You are enhancing a Power BI model that has DAX calculations. You need to create a DAX measure that returns the year-to-date total sales from the same date from the previous calend...

You have a Power BI data model that contains two tables named Products and Sales. A one-to-many relationship exists between the tables. You have a report that contains a report-lev...

You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total. How shou...

You deploy a tabular model to the Power BI service. The model is developed and maintained by using Microsoft Visual Studio. Power BI connects to the model by using the Connect live...

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.DimProduct. You need to write a query to meet the following requirements: - Return the ranked...

You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is...

You plan to deploy a Power BI Premium tenant. You need to specify the capacity of the tenant. Which unit should you use?

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

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

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1. You plan to deploy a data lake that will record the history of transactions...