DP-500 Exam Questions
152 real DP-500 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #51Implement and manage data models
You have a Power BI dataset. The dataset contains data that is updated frequently. You need to improve the performance of the dataset by using incremental refreshes. Which four act...
Power BIIncremental RefreshDataset PerformanceData Model Management - Question #52Query and transform data
You are using DAX Studio to query an XMLA endpoint. You need to identify the duplicate values in a column named Email in a table named Subscription. How should you complete the DAX...
DAXDuplicate DetectionData QueryingTable Functions - Question #53Explore and visualize data
You have the following code in an Azure Synapse notebook. ```python import matplotlib.pyplot as plt x1 = [2, 3, 4] y1 = [5, 9, 5] x2 = [1, 2, 3, 4, 5] y2 = [2, 3, 4] y3 = [6, 8, 7]...
Synapse notebooksmatplotlibdata visualizationscatter plots - Question #54Explore and visualize data
You have the following code in an Azure Synapse notebook: ```python import matplotlib.pyplot as plt x1 = [1, 3, 4, 5, 6, 7, 9] y1 = [4, 7, 2, 4, 7, 8, 3] x2 = [2, 4, 6, 8, 10] y2 =...
MatplotlibData VisualizationBar ChartPython Programming - Question #55Explore and visualize data
You are creating a Power BI Desktop report. You add a Python visual to the report page. You plan to create a scatter chart to visualize the data. You add Python code to the Python...
Power BI Python visualPython data visualizationScatter chartMatplotlib - Question #56Implement and manage a data analytics environment
You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements: - Code must always be merged to the main branch befo...
Azure Synapse AnalyticsGit IntegrationDevOpsBranching Strategy - Question #57Implement and manage a data analytics environment
You need to recommend an automated solution to monitor Power BI user activity. The solution must meet the following requirements: - Security admins must identify when users export...
Power BI MonitoringAudit LogsPower BI AdministrationData Governance - Question #58Query and transform data
Based on a query dependency diagram where 'Orders' is load-disabled and dependent queries 'Order Details', 'Customer', 'Shipper' are loaded, when the dataset refreshes, the Orders...
Query dependenciesLoad-disabled queriesData refreshPower Query execution - Question #59Implement and manage a data analytics environment
Based on a query dependency diagram, which action will reduce data refresh times for this model?
DataflowsRefresh optimizationPower BI performanceData preparation - Question #60Implement and manage a data analytics environment
You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group1) with the requirement to 'Analyze data to create and train machine learning mod...
Azure Synapse AnalyticsApache Spark poolMachine LearningPool types - Question #61Implement and manage a data analytics environment
You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group2) with the requirement to 'Execute complex queries with multiple joins against r...
Azure Synapse AnalyticsDedicated SQL PoolPolyBaseComplex SQL Queries - Question #62Implement and manage a data analytics environment
You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group3) with the requirement to 'Query and load data from Apache Parquet files stored...
Azure Synapse AnalyticsServerless SQL poolData Lake StorageCost management - Question #63Query and transform data
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. Sample data for Sales (OrderID, SalesPerson, Amount) and Commis...
Power Query MTable FunctionsData IntegrationAdvanced Editor - Question #64Query and transform data
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. Sample data for Sales (OrderID, SalesPerson, Amount) and Commis...
Power QueryTable MergeJoin TypesM Language - Question #65Implement and manage data models
You are building a Power BI dataset with a Calendar table and a calculated column `pfFlag = IF ('Calendar'[Date] < TODAY(), "Past", "Future")`. You need a measure for fiscal prior...
DAXTime IntelligenceFiscal YearMeasures - Question #66
You are building a Power BI dataset with a Calendar table and a calculated column `pfFlag = IF ('Calendar'[Date] < TODAY(), "Past", "Future")`. You need a measure for fiscal prior...
- Question #67Query and transform data
You plan to create a Power BI report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service roo...
Power Query ParametersData Source ManagementOData FeedData Source Reusability - Question #68Query and transform data
The query uses the hierarchical namespace of the storage account. Select Yes if the statement is true. Otherwise, select No.
Hierarchical NamespaceAzure Data Lake Storage Gen2Data QueryingStorage Accounts - Question #69Query and transform data
The query uses a custom function to load file data. Select Yes if the statement is true. Otherwise, select No.
Power QueryCustom FunctionsData TransformationLoading File Data - Question #70Implement and manage a data analytics environment
Changing the source to use AzureStorage.DataLake will reduce the load time of the query. Select Yes if the statement is true. Otherwise, select No.
Azure Data Lake StorageData source optimizationQuery performanceData loading - Question #71Implement and manage a data analytics environment
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements. What should you do?
Power BI permissionsDataset securityAd hoc reportingWorkspace management - Question #72Implement and manage a data analytics environment
Which three actions should you include in the recommendation? Each correct answer presents part of the solution.
Sensitivity LabelsPower BI Admin PortalData GovernanceInformation Protection - Question #73Implement and manage a data analytics environment
How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?
Power BI RefreshIncremental RefreshDataset ManagementData Refresh Strategy - Question #74Implement and manage data models
You need to create a measure to count orders for the market basket analysis. How should you complete the DAX expression? To answer, select the appropriate options in the answer are...
DAXMeasuresAggregationData Modeling - Question #75Query and transform data
You need to identify the root cause of the data refresh issue. What should you use?
Query DiagnosticsData RefreshTroubleshootingPower Query - Question #76Implement and manage data models
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.
Power BI performanceDAX StudioPerformance AnalyzerReport optimization - Question #77Implement and manage a data analytics environment
You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users. What should you do?
Azure Synapse AnalyticsServerless SQL PoolDedicated SQL PoolPerformance Optimization - Question #78Implement and manage data models
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.) You need to minimize the model size by eliminating invalid relationsh...
Data Model OptimizationModel Size ReductionColumn ManagementData Modeling Best Practices - Question #79Implement and manage a data analytics environment
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset. You need to recommend an Azure Synapse Analytics pool f...
Azure Synapse AnalyticsApache SparkMachine LearningCost Optimization - Question #80Query 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...
Azure Synapse AnalyticsServerless SQL PoolSchema InferenceQuery Optimization - Question #81Implement and manage data models
BI service to an Azure SQL database since the creation of the deployment pipeline. An investigation into the issue identifies the following: - One of the datasets is larger than 1...
Composite ModelsDirectQueryDataset PerformanceData Model Management - Question #82Explore and visualize data
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...
Power BI AccessibilityVisualizationsAlt TextScreen Readers - Question #83Implement and manage a data analytics environment
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 p...
Microsoft PurviewData GovernanceAzure Synapse AnalyticsData Source Registration - Question #84Explore and visualize data
You have a Power BI tenant. You need to ensure that all reports use a consistent set of colors and fonts. The solution must ensure that the colors and fonts can be applied to exist...
Power BI themesReport designBrandingCustom themes - Question #85Query and transform data
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?
Power BIAPI integrationData ingestionAuthentication - Question #86Query and transform data
The IoT GUID and IoT ID columns are unique to each row in the query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance....
Data TypesData TransformationDate and Time AnalysisDataset Performance - Question #87Query 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...
Power Query EditorData TransformationPerformance OptimizationColumn Management - Question #88Explore and visualize data
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...
Power BI ServiceReport PersonalizationVisualizationsUser Experience - Question #89Implement and manage a data analytics environment
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...
Power BI DesktopData Source ConnectionPBIDS fileConnection Simplification - Question #90Implement and manage a data analytics environment
Hotspot Question You are creating a Power BI dataset from a data source. You want to publish this dataset to Power BI in order to build reports in Azure Synapse Studio. You create...
Power BI PublishingPBIDSSynapse Studio IntegrationData Connectivity - Question #91Implement and manage a data analytics environment
You need to verify that your PBIDS file is functional. For each of the following statements, select Yes if the statement is true. Otherwise, select No. ```yaml version: "0.1", conn...
PBIDSPower BI ConnectivityConnection ModesData Source Configuration - Question #92Implement and manage a data analytics environment
Which of the following service or tools enables you to scan the entire Power BI Tenant and browse Power BI assets, explore enhanced Power BI dataset metadata, and visualize end-to-...
Microsoft PurviewData GovernanceData LineagePower BI Management - Question #93Explore and visualize data
You are assigned to explore data by using Azure Synapse Analytics. You have decided to use Synapse Spark notebook to explore the data. You can read the data using Spark's Dataframe...
Azure Synapse AnalyticsSpark NotebookData VisualizationNotebook UI - Question #94Query and transform data
Which of the following file types is NOT supported by the Serverless SQL Pool in Azure Synapse Analytics?
Azure Synapse AnalyticsServerless SQL PoolFile formats - Question #95Query and transform data
Assume that you are the only Azure Enterprise Data Analyst in your team. Your Project Manager has asked you to look at some techniques to improve data loading for relational data s...
Data Loading OptimizationPower BI PerformanceRelational Database OptimizationData Model Best Practices - Question #96Implement and manage a data analytics environment
Which of the following is not a valid option to analyze data using Azure Synapse Analytics?
Azure Synapse AnalyticsSynapse PoolsData Analysis ComputeAzure Services - Question #97Implement and manage data models
Which of the two scenarios from the list below can be implemented using DirectQuery mode in Power BI? (Choose two) A. When a report needs to be refreshed frequently based on the us...
DirectQueryPower BI data connectivityData refreshData volume - Question #98Implement and manage data models
As a Lead Azure Enterprise Data Analyst, you have been asked to select an external tool that can support the features or functionalities listed below: - Ability to easily build, ma...
Tabular ModelsModel ManagementExternal ToolsTabular Editor - Question #99Implement and manage a data analytics environment
Assume that you are responsible for designing a deployment pipeline for your project's Power BI assets. As part of the deployment strategy which item from the following list CAN NO...
Power BI Deployment PipelinesPower BI AssetsDeployment StrategyPower BI Service - Question #100Explore and visualize data
As an Azure enterprise Data Analyst, you are assigned to create a custom theme that can be used for your Power BI Reports. You have decided to create a new theme that matches your...
Power BI Custom ThemesReport DesignJSON Format