DP-700 Exam Questions
127 real DP-700 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51Monitor and optimize a data analytics solution
You have implemented synchronous mirroring for your data warehouse. You are experiencing performance issues during peak workloads. Which of the following techniques can help improv...
Data Warehousing PerformanceSynchronous MirroringNetwork LatencyPerformance Optimization - Question #52Design and implement data ingestion and transformation
You need to create a pipeline to ingest data from a variety of sources, including SQL Server databases, CSV files, and JSON files. Which of the following pipeline design strategies...
Data IngestionPipeline DesignAzure Data FactoryData Integration - Question #53Monitor and optimize a data analytics solution
You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a notebook named Notebook1. You need to identify which version of Delta was used when Notebo...
Fabric MonitoringNotebook executionDelta Lake versionActivity Monitoring - Question #54Monitor and optimize a data analytics solution
You have a Fabric workspace that contains a semantic model named Model1. You need to dynamically execute and monitor the refresh progress of Model1. What should you use?
Fabric semantic modelNotebooksSemantic LinkData refresh management - Question #55
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...
- Question #56Design and implement data ingestion and transformation
You have a Fabric workspace that contains an eventstream named Eventstream1. Eventstream1 processes data from a thermal sensor by using event stream processing, and then stores the...
Fabric EventstreamStream ProcessingAggregate FunctionsData Transformation - Question #57Ingest and transform data
You have an Azure event hub. Each event contains the following fields: - BikepointID - Street - Neighbourhood - Latitude - Longitude - No_Bikes - No_Empty_Docks You need to ingest...
Event ingestionStream processingData filteringFabric Lakehouse - Question #58Design and implement data ingestion and transformation
Which of the following actions would be most likely to resolve this error ?
Data qualityDuplicate keysData cleansingData transformation - Question #59Monitor and optimize a data analytics solution
You have a data warehouse that is experiencing performance issues during data loading. The data warehouse is using a partitioned table. You have noticed that the data loading proce...
Data Loading OptimizationTable PartitioningData Warehouse PerformanceParallel Processing - Question #60Manage data governance and security
You want to delegate workspace administration tasks to a specific team within your organization. You want to ensure that they have the necessary permissions to manage the workspace...
Azure Synapse AnalyticsRole-Based Access Control (RBAC)Workspace AdministrationPermissions - Question #61Design and implement data ingestion and transformation
You need to create a simple ETL pipeline that extracts data from a SQL Server database, performs basic data cleaning, and loads the data into a data warehouse. Which of the followi...
ETL pipelineDataflows Gen2T-SQLData Warehouse - Question #62Manage data governance and security
Your organization wants to classify data based on its sensitivity and regulatory requirements. Which of the following methods would be most appropriate for implementing data classi...
Data ClassificationMicrosoft PurviewSensitivity LabelsData Governance - Question #63Manage data governance and security
You're working with a Microsoft Fabric dataset containing sensitive customer information. You need to ensure that different users can only see their data. Which of the following me...
Row-Level Security (RLS)Data SecurityMicrosoft FabricUser Access Control - Question #64Design and implement data ingestion and transformation
You're tasked with building a real-time analytics pipeline for a high-volume, low-latency application. The data source is a Kafka topic producing millions of events per second. Whi...
Real-time analyticsStreaming dataAzure Stream AnalyticsKafka integration - Question #65Monitor and optimize an analytics solution
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than sev...
LakehouseDelta LakeData maintenanceVACUUM command - Question #66Monitor and optimize a data analytics solution
You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is schedule...
Pipeline MonitoringTroubleshootingCopy Data ActivityDynamic SQL - Question #67Monitor and optimize a data analytics solution
You have a Fabric notebook named Notebook1 that has been executing successfully for the last week. During the last run, Notebook1 executed nine jobs. You need to view the jobs in a...
Fabric notebooksSpark job monitoringApplication run details - Question #68Design and implement data ingestion and transformation
You need to schedule the population of the medallion layers to meet the technical requirements. What should you do?
Data OrchestrationMedallion ArchitectureData PipelinesScheduling - Question #69Ingest and transform data
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns. Table name | Column name | Description ---|---|--- SalesOrderDetail...
SQL QueriesAggregationGrouping FunctionsData Transformation - Question #70Design and implement data ingestion and transformation
You need to ensure that processes for the bronze and silver layers run in isolation. How should you configure the Apache Spark settings?
Apache SparkDatabricks ClustersWorkload IsolationCluster Configuration - Question #71Manage data governance and security
You need to ensure that the authors can see only their respective sales data. How should you complete the statement? To answer, drag the appropriate values the correct targets. Eac...
Row-Level Security (RLS)Data SecurityAccess Control - Question #72Monitor and optimize 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...
Azure Fabric NotebooksAzure Key VaultSecure Credential ManagementFabric API Authentication - Question #73Manage data governance and security
You have a Fabric workspace named Workspace1 that contains the following items: - A Microsoft Power BI report named Report1 - A Power BI dashboard named Dashboard1 - A semantic mod...
Fabric governanceContent endorsementPower BI itemsLakehouse management - Question #74Implement and manage an analytics solution
You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses. You need to configure source control for Workspace1 to use GitHub. The solution must follow the...
Source ControlGitHubFabric IntegrationPermissions - Question #75Implement and manage an analytics solution
You have a Fabric workspace named Workspace1. You plan to configure Git integration for Workspace1 by using an Azure DevOps Git repository. An Azure DevOps admin creates the requir...
Fabric Git integrationAzure DevOpsWorkspace managementVersion control - Question #76Design and implement data ingestion and transformation
You have a Fabric workspace that contains a lakehouse and a semantic model named Model1. You use a notebook named Notebook1 to ingest and transform data from an external data sourc...
Data PipelinesSchedulingRetry PoliciesConditional Execution - Question #77Ingest and transform data
You have a Fabric workspace that contains a lakehouse named Lakehouse1. You plan to create a data pipeline named Pipeline1 to ingest data into Lakehouse1. You will use a parameter...
Pipeline parametersDynamic contentFabric pipelinesExpression language - Question #78Design and implement data ingestion and transformation
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Workspace1 contains the following items: - A Dataflow Gen2 dataflow that copies data from a...
Data OrchestrationFabric PipelinesSchedulingMicrosoft Fabric - Question #79
You are building a Fabric notebook named MasterNotebook1 in a workspace. MasterNotebook1 contains the following code. DAG = { "activities": [ { "name": "execute_notebook_1", "path"...
- Question #80Design and implement data ingestion and transformation
You have a Fabric workspace that contains a data pipeline named Pipeline1 as shown in the exhibit. (Click the Exhibit tab.) What will occur next time Pipeline1 runs?
Data pipeline activitiesPipeline executionActivity propertiesFabric workspace - Question #81Implement and manage an analytics solution
You need to ensure that WorkspaceA can be configured for source control. Which two actions should you perform? Each correct answer presents part of the solution.
Source ControlGit IntegrationTenant SettingsWorkspace Configuration - Question #82Design and implement data ingestion and transformation
You have two Fabric notebooks named Load_Salesperson and Load_Orders that read data from Parquet files in a lakehouse. Load_Salesperson writes to a Delta table named dim_salesperso...
Fabric notebooksNotebook orchestrationData pipelinesDelta Lake - Question #83Manage data governance and security
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse2. A team of data analysts has Viewer role access to Workspace1. You create a table by running...
Dynamic Data MaskingData SecurityFabric WarehouseColumn-level security - Question #84Design and implement data ingestion and transformation
Hotspot Question You are building a data orchestration pattern by using a Fabric data pipeline named Dynamic Data Copy as shown in the exhibit. (Click the Exhibit tab.)
Fabric data pipelineData orchestrationDynamic Data CopyData ingestion - Question #85Design and implement data ingestion and transformation
Dynamic Data Copy does NOT use parametrization. You need to configure the ForEach activity to receive the list of tables to be copied. How should you complete the pipeline expressi...
Azure Data FactoryForEach activityPipeline expressionsDynamic data copy - Question #86Manage data governance and security
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named DimCustomers. DimCustomers contains the following columns: - CustomerName...
Microsoft FabricDynamic Data MaskingData Warehouse SecuritySQL Security - Question #87Manage data governance and security
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named Customer. Customer contains the following data (CustomerID, FirstName, Las...
Fabric Warehouse securityColumn-level securityData access controlPermissions - Question #88Design and implement data ingestion and transformation
Which two components should you include in the workflow? Each correct answer presents part of the solution.
streaming dataflowreal-time processingdata ingestiondata transformation - Question #89Design and implement data modeling
You are implementing a medallion architecture in a Fabric lakehouse. You plan to create a dimension table that will contain the following columns: - ID - CustomerCode - CustomerNam...
Slowly Changing Dimensions (SCD)Data ModelingDimension TablesLakehouse Architecture - Question #90Design and implement data ingestion and transformation
You have a Fabric workspace named EventStream1. EventStream1 outputs events to a table named Table1 in a lakehouse. The streaming data is sourced from motorway sensors and represen...
Stream ProcessingWindowing FunctionsMicrosoft FabricEventStream - Question #91Design and implement data ingestion and transformation
You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension (SCD) dimension table named DimCustomer. DimCustomer contains 100 columns and 20 million rows...
SCDData TransformationPerformance OptimizationHashing - Question #92Design and implement data ingestion and transformation
You have an Azure SQL database named DB1. In a Fabric workspace, you deploy an eventstream named EventStreamDB1 to stream record changes from DB1 into a lakehouse. You discover tha...
Change Data Capture (CDC)Azure SQL DatabaseData IngestionEventstream - Question #93Design and implement data ingestion and transformation
You need to recommend a solution to resolve the MAR1 connectivity issues. The solution must minimize development effort. What should you recommend?
Azure Synapse PipelinesError HandlingRetriesCopy Data Activity - Question #94Monitor and optimize an analytics solution
You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?
Delta LakeVACUUM commandData MaintenanceStorage Optimization - Question #95Design and implement data modeling
You have a Fabric warehouse named DW1 that contains four staging tables named ProductCategory, ProductSubcategory, Product, and SalesOrder. ProductCategory, ProductSubcategory, and...
Dimensional ModelingStar SchemaData Warehouse DesignFabric Warehouse - Question #96Design and implement data ingestion and transformation
Your company has three newly created data engineering teams named Team1, Team2, and Team3 that plan to use Fabric. The teams have the following personas: - Team1 consists of member...
Fabric Dataflows Gen2Fabric Spark NotebooksFabric Data PipelinesData Ingestion and Transformation - Question #97Design and implement data ingestion and transformation
You plan to process the following three datasets by using Fabric: Dataset1: This dataset will be added to Fabric and will have a unique primary key between the source and the desti...
Fabric Data IntegrationFabric Data WarehouseDataflow Gen2Spark Notebooks - Question #98Design and implement data ingestion and transformation
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Status_Target that has the following columns: - Key - Status - LastModifie...
Incremental LoadingDelta Lake MergeSpark DataFramesData Transformation - Question #99Design and implement data ingestion and transformation
You are building a data loading pattern by using a Fabric data pipeline. The source is an Azure SQL database that contains 25 tables. The destination is a lakehouse. In a warehouse...
Fabric Data PipelinesDynamic IngestionAzure SQL DatabaseLakehouse - Question #100Design and implement data ingestion and transformation
You have a table in a Fabric lakehouse that contains the following data: | SalesOrderNumber | OrderDate | CustomerName | Email | |------------------|------------|----------------|-...
PySparkDataFrame OperationsData CleaningData Transformation