DP-600 Exam Questions
145 real DP-600 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1Plan, implement, and manage a solution for data analytics
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 version controlAzure ReposWorkspace management - Question #2Implement and manage semantic models
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...
Incremental RefreshDataflow Gen2Azure Data FactorySemantic Model Management - Question #3Prepare 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 LakehouseSpark NotebookShortcutsData Access - Question #5Prepare and serve data
Case Study 2 - Litware, Inc Overview Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, anal...
Fabric Dataflow Gen2Data IngestionLow-Code ETLAnalytics Engineers - Question #6Plan, implement, and manage a solution for data analytics
Case Study 2 - Litware, Inc Overview Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, anal...
Fabric LakehouseData Store ArchitectureData ModelingMicrosoft Fabric - Question #11Prepare and serve data
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: Table1: A Delta table created by using a short...
Fabric LakehouseSQL endpointTable typesData access - Question #12Prepare data
You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a PowerQuery step to identify the maximu...
Power Query MData ProfilingDataflowsFabric Warehouse - Question #13Prepare and serve data
You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the PREDICT function in...
Fabric NotebooksMachine LearningModel ScoringPREDICT function - Question #14Explore and analyze data
You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manu...
Fabric NotebooksSpark DataFramedisplay functionData Exploration - Question #15Implement and manage semantic models
You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplic...
Power BIPython VisualData AggregationSummarization - Question #16Prepare data
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows. You view the query in Power Query as shown in...
Power Query EditorData ProfilingData Quality - Question #17Implement and manage semantic models
You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1. You need to ensure read-write access to D...
XMLA endpointCapacity settingsSemantic model managementData access - Question #18Plan, implement, and manage a solution for data analytics
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability...
Fabric AdministrationXMLA EndpointsSemantic Model ManagementTenant & Capacity Settings - Question #19Implement and manage semantic models
You are creating a semantic model in Microsoft Power BI Desktop. You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Micr...
PBIPTMDLSemantic ModelPower BI File Formats - Question #20Plan, implement, and manage a solution for data analytics
You plan to deploy Microsoft Power BI items by using Fabric deployment pipelines. You have a deployment pipeline that contains three stages named Development, Test, and Production....
Fabric deployment pipelinesPower BI securityRole-based access control (RBAC)Least privilege - Question #21Implement and manage semantic models
You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bi report named Report...
Power BI PerformanceDirectQueryAggregationsMicrosoft Fabric - Question #22Implement and manage semantic models
You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as...
Incremental RefreshQuery FoldingPerformance OptimizationData Refresh Failure - Question #23Implement and manage semantic models
You have a Fabric tenant that uses a Microsoft Power BI Premium capacity. You need to enable scale-out for a semantic model. What should you do first?
Semantic Model ConfigurationScale-outLarge Dataset Storage FormatPower BI Premium - Question #24Implement and manage semantic models
You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the w...
Direct LakeRow-Level Security (RLS)Semantic Model Query ModesFabric Warehouse - Question #25Implement and manage semantic models
You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to creat...
Power BI DesktopModel ViewData ModelingSemantic Model - Question #26Implement and manage semantic models
You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode. You suspect that some DAX queries load unnecessary columns into memory. You need to identi...
Fabric Semantic ModelsDirect LakeMemory OptimizationDMV - Question #27Implement and manage semantic models
You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following f...
Semantic Model OptimizationData Model PerformanceMemory ManagementData Refresh - Question #28Implement and manage semantic models
You have a Fabric tenant that contains a semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use...
Semantic Model ManagementImplicit MeasuresPower BI DesktopTabular Editor - Question #29Prepare and serve data
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Tablet. You are creating a new data pipeline. You plan to copy external data...
Fabric Data PipelinesCopy data activityLakehouseData ingestion strategy - Question #30Prepare and serve data
You have a Fabric tenant that contains a lakehouse. You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3)...
Fabric LakehouseData formatsParquetShortcuts - Question #31Prepare and serve data
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files int...
Fabric LakehouseData IngestionDelta LakeV-Order Optimization - Question #32Plan, implement, and manage a solution for data analytics
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains an unpartitioned table named Table1. You plan to copy data to Table1 and partition the tabl...
Microsoft FabricData PipelinesCopy ActivityLakehouse Partitioning - Question #33Plan, implement, and manage a solution for data analytics
You have source data in a folder on a local computer. You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements...
Microsoft FabricLakehouseDataflowsDelta Lake Optimization - Question #34Prepare data
You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit. You need to transform...
Data TransformationUnpivotFabric DataflowsPower Query - Question #35Maintain a data analytics solution
You have a Fabric tenant that contains a data pipeline. You need to ensure that the pipeline runs every four hours on Mondays and Fridays. To what should you set Repeat for the sch...
Microsoft FabricData PipelinesSchedulingPipeline Orchestration - Question #36Maintain a data analytics solution
You have a Fabric tenant that contains a warehouse. Several times a day, the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used b...
Fabric CapacityPerformance MonitoringThrottlingData Warehouse - Question #37Maintain a data analytics solution
You have a Fabric tenant that contains a warehouse. A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not render...
Fabric WarehouseQuery MonitoringPerformance TroubleshootingDMVs - Question #38Plan, implement, and manage a solution for data analytics
You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of th...
Slowly Changing Dimensions (SCD)SCD Type 1Data LoadingDimension Modeling - Question #39Prepare and serve data
You are analyzing customer purchases in a Fabric notebook by using PySpark. You have the following DataFrames: - transactions: Contains five columns named transaction_id, customer_...
PySparkDataFrame JoinBroadcast JoinData Shuffling - Question #40Explore 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 ExplorationData Profiling - Question #41Explore 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...
PySparkDataFrameData ExplorationDescriptive Statistics - Question #42Explore 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 explorationDescriptive statistics - Question #43Maintain 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 #44Maintain 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 SQLData Optimization - Question #45Maintain 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...
Spark SQLDelta LakeTable maintenanceQuery performance - Question #60Plan, implement, and manage a solution for data analytics
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 capacityCapacity SKUsBilling models - Question #61Implement and manage semantic models
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...
Calculation GroupsSemantic ModelsTabular EditorAdvanced Data Modeling - Question #62Plan, implement, and manage a solution for data analytics
Case Study 2 - Litware, Inc Overview Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, anal...
Fabric Admin SettingsSecurity and Access ControlTenant ManagementProof of Concept (PoC) - Question #63Prepare and serve data
Case Study 2 - Litware, Inc Overview Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, anal...
Date DimensionFabric Dataflow Gen2Fabric PipelineData Ingestion - Question #64Plan, implement, and manage a solution for data analytics
Case Study 2 - Litware, Inc Overview Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, anal...
Data OrchestrationData PipelinesData LoadingETL/ELT - Question #68Implement and manage semantic models
You have an Azure Repos repository named Repo1 and a Fabric-enabled Microsoft Power BI Premium capacity. The capacity contains two workspaces named Workspace1 and Workspace2. Git i...
Power BI Project (PBIP)Semantic ModelVersion ControlCI/CD - Question #69Prepare data
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. In Workspace1, you create a data pipeline named Pipeline1. You have CSV files stored in an...
Fabric PipelinesDataflow Gen2Power Query MData Ingestion - Question #70Prepare data
You have a Fabric tenant that contains a lakehouse. You plan to use a visual query to merge two tables. You need to ensure that the query returns all the rows in both tables. Which...
SQL JoinsFull Outer JoinMicrosoft FabricLakehouse Querying - Question #71Maintain a data analytics solution
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table that has one million Parquet files. You need to remove files that were NOT re...
Delta LakeData ManagementLakehouseVACUUM command - Question #72Prepare data
You have a Fabric workspace named Workspace1 and an Azure SQL database. You plan to create a dataflow that will read data from the database, and then transform the data by performi...
DataflowsData transformationFuzzy matchingQuery merging