DP-500 Exam Questions
152 real DP-500 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #101Explore and visualize data
Power BI supports R language for creating visuals. Which two statements from below are correct in this regard? (Choose two)
R integrationPower BI visualsExternal toolsSetup prerequisites - Question #102Explore and visualize data
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...
Azure Synapse NotebooksData VisualizationCharting - Question #103Explore and visualize data
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")...
Azure Synapse AnalyticsPythonData VisualizationSeaborn - Question #104Implement and manage data models
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...
Data ModelingData Model RelationshipsPower BIData Model Analysis - Question #105Implement and manage a data analytics environment
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...
Incremental RefreshPower Query MPower BI DesktopDataset Management - Question #106Query and transform data
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?...
Azure Synapse AnalyticsServerless SQL PoolT-SQL FunctionsFile Metadata - Question #107Query and transform data
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...
Azure Synapse AnalyticsServerless SQL poolOPENROWSETData Lake querying - Question #108Implement and manage a data analytics environment
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...
Data PrivacyPower QueryData FirewallPower BI Service - Question #109Explore and visualize data
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...
Power BI Report BuilderPaginated ReportsReport ParametersDefault Values - Question #110Implement and manage a data analytics environment
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...
XMLA endpointPower BI PremiumData ConnectivityDataset Management - Question #111Implement and manage data models
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...
DAXTime IntelligenceMeasuresPower BI - Question #112Explore and visualize data
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...
Azure Synapse AnalyticsApache SparkData VisualizationPython - Question #113Implement and manage data models
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...
Hybrid TablesPower BI PremiumData Model OptimizationDirectQuery Partitions - Question #114Implement and manage a data analytics environment
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...
Power BI AdministrationExternal UsersAzure AD B2BTenant Settings - Question #115Implement and manage a data analytics environment
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)....
Paginated ReportsPower BI SubscriptionsPower BI WorkspacesPremium Per User (PPU) - Question #116Query and transform data
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...
Data TransformationPerformance OptimizationPower Query EditorColumn Management - Question #117Implement and manage a data analytics environment
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...
Azure Data Lake Storage Gen2Power BI DataflowsAzure RBACLeast Privilege - Question #118Implement and manage a data analytics environment
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...
Power BI DataflowsAzure Data Lake Storage Gen2Workspace IntegrationDataflow Management - Question #119Explore and visualize data
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...
Azure Synapse AnalyticsSpark DataFramedisplay commandData profiling - Question #120Implement and manage a data analytics environment
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...
Power BI PremiumPower BI Premium Per UserCapacity ManagementPerformance Optimization - Question #121Implement and manage a data analytics environment
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...
Power BI PremiumCapacity ManagementPerformance OptimizationDataset Refresh - Question #122Implement and manage a data analytics environment
Which two actions should you recommend? Each correct answer presents part of the solution.
Impact AnalysisPower BI Template AppsEnterprise SolutionsSolution Deployment - Question #123Implement and manage a data analytics environment
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...
Power BI SecurityData Sharing ControlTenant SettingsData Governance - Question #124Implement and manage data models
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...
View creationData modelingCalculated tablesDAX - Question #125Implement and manage a data analytics environment
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...
Power BI DeploymentWorkspace ManagementReport and Dataset ManagementTechnical Requirements - Question #126Implement and manage data models
What should the team do first?
Power BI PerformancePerformance AnalyzerDAX OptimizationTroubleshooting - Question #127Implement and manage a data analytics environment
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?
Linked ServiceAzure Synapse AnalyticsData IntegrationWorkflow Optimization - Question #128Implement and manage a data analytics environment
You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace. What should you do?
Power BI AdministrationService PrincipalsPower BI APIsDeployment - Question #129Implement and manage a data analytics environment
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?
Power BI tenant settingsExternal sharingSecurity controlsData governance - Question #130Implement and manage data models
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....
Data Model OptimizationTroubleshootingDAX StudioPower Query - Question #131Implement and manage data models
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...
Object-Level SecurityPower BI DAX SecurityTabular EditorHybrid Identity - Question #132Implement and manage data models
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...
DAXFilter ContextDisconnected TablesCross-Table Filtering - Question #133Query and transform data
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...
Power QueryM languageCustom FunctionsData Transformation - Question #134Query and transform data
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...
Dataset refresh optimizationPower Query transformationsComputed columnsDataflows - Question #135Implement and manage a data analytics environment
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...
Azure Synapse AnalyticsMachine Learning ScoringT-SQL PREDICT functionONNX model format - Question #136Implement and manage data models
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...
Data ModelingPerspectivesTabular EditorReport Personalization - Question #137Implement and manage a data analytics environment
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...
Synapse NotebooksPySparkMagic CommandsSpark Environment - Question #138Explore and visualize data
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...
Report PersonalizationPower BI ServiceVisual CustomizationSelf-service BI - Question #139Explore and visualize data
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...
Data VisualizationPySparkAzure Synapse AnalyticsPython Libraries - Question #140Explore and visualize data
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...
Data VisualizationColumn ChartsAzure Synapse AnalyticsSpark Notebooks - Question #141Implement and manage data models
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...
DAXTime IntelligenceMeasuresCALCULATE - Question #142Implement and manage data models
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...
Data ModelingPower BI RelationshipsFilter ContextRelationship Direction - Question #143Implement and manage data models
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...
DAXPower BI MeasuresData VisualizationChart Configuration - Question #144Implement and manage a data analytics environment
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...
Source ControlAzure DevOpsTabular Model ALMPower BI Report ALM - Question #145Query and transform data
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...
SQL Window FunctionsRanking FunctionsNTILEAzure Synapse Analytics SQL Pool - Question #146Implement and manage data models
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...
Calculation GroupsDAXPower BI Data Modeling - Question #147Implement and manage a data analytics environment
You plan to deploy a Power BI Premium tenant. You need to specify the capacity of the tenant. Which unit should you use?
Power BI PremiumCapacity Planningv-coresDeployment - Question #148Query and transform data
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...
Data typesPower QueryData transformationTime Series Models - Question #149Query and transform data
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...
Azure Synapse AnalyticsONNX modelsModel scoringPREDICT function - Question #150Implement and manage a data analytics environment
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...
Synapse Serverless SQL PoolData Lake File FormatsData IngestionBatch Atomicity