DP-600 Exam Questions
145 real DP-600 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #73Prepare and serve data
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains two schemas name schema1 and schema2 and a table named schema1.city. You need to make a cop...
T-SQLFabric WarehouseData cloningZero-copy operations - Question #74Implement and manage semantic models
You have a Fabric tenant that contains a lakehouse named Lakehouse1. You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model...
Fabric LakehouseSQL Analytics EndpointSemantic ModelData Model Configuration - Question #75Prepare data
You have a Fabric tenant. You are creating an Azure Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the c...
Fabric pipelinesLookup activityStored proceduresData orchestration - Question #76Prepare and serve data
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakeh...
Microsoft FabricLakehouseShortcutsData Integration - Question #77Plan, implement, and manage a solution for data analytics
You have a Fabric tenant that contains a warehouse. You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slow...
Slowly Changing DimensionsDimension ModelingData WarehousingStar Schema - Question #78Plan, implement, and manage a solution for data analytics
You have a Fabric tenant. You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that will execute in sequence. You need to ensure that a failure...
Microsoft FabricData PipelinesActivity DependenciesConditional Paths - Question #79Implement and manage semantic models
You have a Microsoft Power BI semantic model. You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The...
Tabular EditorBest PracticesSemantic ModelSurrogate Keys - Question #80Implement and manage semantic models
You have a Fabric tenant that contains a semantic model. The model contains 15 tables. You need to programmatically change each column that ends in the word Key to meet the followi...
Semantic ModelTabular EditorMetadata ManagementData Modeling Tools - Question #81Maintain a data analytics solution
You have a Microsoft Power BI report named Report1 that uses a Fabric semantic model. Users discover that Report1 renders slowly. You open Performance analyzer and identify that a...
Power BI performanceReport optimizationPerformance AnalyzerVisual rendering - Question #82Implement and manage semantic models
You have a custom Direct Lake semantic model named Model1 that has one billion rows of data. You use Tabular Editor to connect to Model1 by using the XMLA endpoint. You need to ens...
Direct LakeSemantic ModelsTabular EditorXMLA Endpoints - Question #83Implement and manage semantic models
You have a Microsoft Power BI semantic model that contains measures. The measures use multiple CALCULATE functions and a FILTER function. You are evaluating the performance of the...
DAX OptimizationKEEPFILTERSFILTER functionPerformance Tuning - Question #84Implement and manage semantic models
You have a semantic model named Model1. Model1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters...
Row-Level Security (RLS)Semantic ModelsTesting & ValidationPower BI / Fabric - Question #85Prepare and serve data
You have a Microsoft Fabric tenant that contains a dataflow. You are exploring a new semantic model. From Power Query, you need to view column information as shown in the following...
Power Query EditorData ProfilingColumn QualityData View Options - Question #86Explore and analyze data
You have a Fabric notebook that has the Python code and output shown in the following exhibit. Which type of analytics are you performing?
Descriptive analyticsTypes of analyticsData analysis conceptsFabric notebooks - Question #87Prepare and serve data
You have a Fabric tenant that contains JSON files in OneLake. The files have one billion items. You plan to perform time series analysis of the items. You need to transform the dat...
PySparkLarge-scale Data ProcessingData TransformationFabric Notebooks - Question #88Explore and analyze data
You have a Fabric tenant that contains customer churn data stored as Parquet files in OneLake. The data contains details about customer demographics and product usage. You create a...
Types of analyticsDescriptive analyticsData explorationData visualization - Question #89Prepare data
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data. You need to identify the min and max values for each colu...
Data profilingPower QueryMicrosoft Fabric Dataflows - Question #90Explore and analyze data
You have a Fabric tenant that contains a Microsoft Power BI report. You are exploring a new semantic model. You need to display the following column statistics: - Count - Average -...
Power QueryData ProfilingColumn StatisticsSemantic Model - Question #91Maintain a data analytics solution
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...
Delta LakeTable maintenanceSpark SQLLakehouse - Question #92Explore and analyze 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...
PySparkSpark DataFrameData ProfilingExploratory Data Analysis - Question #93Implement and manage semantic models
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...
DAX OptimizationQuery Performance TuningSemantic Model PerformanceRELATEDTABLE function - Question #94Implement and manage semantic models
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...
DAX optimizationSemantic model performanceQuery optimizationDAX functions - Question #95Implement and manage semantic models
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...
DAX optimizationSemantic model performanceDAX filtersCOUNTROWS function - Question #98Prepare data
Drag and Drop Question You are building a solution by using a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. The DataFrame returns four columns. You n...
Spark DataFrameData Type ConversionPySpark - Question #110Implement and manage semantic models
You are developing a complex semantic model that contains more than 20 date columns. You need to conform the date format for all the columns as quickly as possible. What should you...
Semantic ModelTabular EditorData FormattingModel Management Tools - Question #111Implement and manage semantic models
You have a Fabric workspace that contains a complex semantic model for a Microsoft Power BI report. You need to optimize the semantic model for analytical queries and use denormali...
Semantic Model OptimizationDenormalizationSnowflake SchemaData Modeling - Question #112Prepare and serve data
You have a Fabric workspace that contains a Microsoft Power BI report named Report1. Your organization does not currently have an enterprise data warehouse. You need to leverage da...
DataflowsStaging DataData IngestionData Pipeline Design - Question #113Implement and manage semantic models
You are developing a Microsoft Power BI semantic model. Two tables in the data model are not connected in a physical relationship. You need to establish a virtual relationship betw...
DAXVirtual RelationshipsTREATASSemantic Models - Question #114Prepare data
You have a Fabric tenant that contains a lakehouse named Lakehouse1. You have forecast data stored in Azure Data Lake Storage Gen2. You plan to ingest the forecast data into Lakeho...
Data IngestionFabric PipelinesLakehouseADLS Gen2 - Question #115Prepare and serve data
You have a Fabric tenant that contains a lakehouse named Lakehouse1. You plan to use Dataflow Gen2 to ingest and transform data from an Azure SQL Database into Lakehouse1. Which la...
Fabric Dataflow Gen2M languageData transformationPower Query - Question #116Prepare and serve data
You are managing a set of Dataflow Gen2 queries that are currently ingesting tables into a Fabric lakehouse. You need to ensure that the tables are optimized for Direct Lake connec...
Fabric LakehouseDirect Lake OptimizationV-OrderDelta Lake - Question #117Prepare data
You have a Fabric tenant that contains a warehouse named Warehouse1. You have a large 1 TB dataset in an external data source. You need to recommend a method to ingest the dataset...
Data IngestionMicrosoft FabricCopy Data ActivityWarehouse - Question #118Maintain a data analytics solution
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta Parquet table named FactSales. You use a Describe command to review the history...
Delta LakeTable MaintenanceFabric LakehouseData Retention - Question #119Prepare and serve data
You have a Fabric tenant that contains a lakehouse named Lakehouse1. You have an external Snowflake database that contains a table with 200 million rows. You need to use a data pip...
Data IngestionFabric Data PipelinesCopy ActivityPerformance Optimization - Question #120Explore and analyze 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...
PySparkData ExplorationDescriptive StatisticsDataFrames - Question #121Prepare and serve data
You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the c...
Fabric Data FactoryPipeline activitiesLookup activityStored procedures - Question #122Implement and manage semantic models
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...
DAX OptimizationSemantic Model PerformanceDAX FunctionsQuery Performance - Question #123Prepare data
Case Study 1 - Contoso Overview Contoso, Ltd. is a US-based health supplements company. Contoso has two divisions named Sales and Research. The Sales division contains two departme...
Fabric LakehouseSpark NotebooksDelta LakeData Access - Question #124Implement and manage semantic models
You have a Microsoft Power BI Premium Per User (PPU) workspace that contains a semantic model. You have an Azure App Service app named App1 that modifies row-level security (RLS) f...
Managed IdentityXMLA EndpointService AccountAuthentication - Question #125Plan, implement, and manage a solution for data analytics
You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the c...
Fabric Data FactoryPipeline ActivitiesLookup ActivityStored Procedure Execution - Question #126Plan, implement, and manage a solution for data analytics
You have an Amazon Web Services (AWS) subscription that contains an Amazon Simple Storage Service (Amazon S3) bucket named bucket1. You have a Fabric tenant that contains a lakehou...
OneLake ShortcutsAWS S3 IntegrationData ConnectionAuthentication - Question #127Prepare data
You have a Fabric tenant that contains a data warehouse. You need to load rows into a large Type 2 slowly changing dimension (SCD). The solution must minimize resource usage. Which...
Slowly Changing Dimensions (SCD)MERGE statementData WarehousingT-SQL optimization - Question #128Prepare and serve data
Case Study 1 - Contoso Overview Contoso, Ltd. is a US-based health supplements company. Contoso has two divisions named Sales and Research. The Sales division contains two departme...
Fabric LakehouseNotebook data accessDelta LakeLakehouse shortcuts - Question #129Implement and manage semantic models
You have a Fabric tenant that contains a lakehouse named LH1. You create new tables in LH1. You need to ensure that the tables are added automatically to the default semantic model...
Fabric LakehouseSemantic ModelData SynchronizationLakehouse Settings - Question #130Plan, implement, and manage a solution for data analytics
You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the c...
Fabric Data FactoryPipeline ActivitiesLookup ActivityStored Procedures - Question #131Implement and manage semantic models
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether th...
Dynamic RLSDAX Identity FunctionsSemantic ModelsUser Principal Name (UPN) - Question #132Implement and manage semantic models
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether th...
DAX FunctionsRow-Level Security (RLS)User Principal Name (UPN)Semantic Model Security - Question #138Prepare and serve data
You have a Fabric tenant that contains a warehouse named DW1 and a lakehouse named LH1. DW1 contains a table named Sales.Product. LH1 contains a table named Sales.Orders. You plan...
CTASSQL DDLData TransformationFabric Data Warehousing - Question #139Implement and manage semantic models
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether th...
Dynamic RLSDAXSemantic ModelMicrosoft Fabric - Question #140Plan, implement, and manage a solution for data analytics
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2 and a user named User1. You need to ensure that User1 can perform the following tasks: - Creat...
Microsoft FabricDomainsRole-based access control (RBAC)Least Privilege