DP-700 Exam Questions

You need to ensure that the data analysts can access the gold layer lakehouse. What should you do?

You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements. What should you do?

You need to recommend a method to populate the POS1 data to the lakehouse medallion layers. What should you recommend for the Bronze layer?

You need to create the product dimension. How should you complete the Apache Spark SQL code? To answer, select the appropriate options in the answer area.

You need to implement the solution for the book reviews. Which should you do?

When the authors have new book releases, there is often an increase in sales activity. This increase slows the data ingestion process. The company's sales team reports that during...

You have a fabric workspace. You have semi-structured data. You need to read the data by using T-SQL, KQL, and Apache Spark. What will only be written by using Spark. What should y...

You have a Fabric workspace that contains a warehouse named Warehouse1. You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premis...

You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway. You need to copy data from Database1 to Warehouse1. Whi...

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modeled by using MDS metadata. Surrogate keys. DW1 contains a single...

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns. Name Descripti...

You have a Fabric workspace named Workspace1 that contains a notebook named Notebook1. In Workspace1, you create a new notebook named Notebook2. You need to ensure that you can att...

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: - Orders - Customer - Employee The Employee table...

You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives. You plan to implement row-level security (RLS). Yo...

You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod. You need to deploy an eventhouse as part of the deployment process. What should you use...

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse1 to a new workspace named Workspace2. As part of the deploymen...

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse. Users report that from OneLake the explorer, they cannot see the data from the eventh...

You have a Fabric workspace named Workspace1. You plan to integrate Workspace1 with Azure DevOps. You will use a Fabric deployment pipeline named deployPipeline1 to deploy items fr...

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 creates a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts shown...

QUESTION 22 You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1. You have an Azure SQL database named Source1 that has public inter...

QUESTION 23 You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2. You have the Delta Parquet files shown in the following table. N...

QUESTION 24 Your company has a sales department that uses two Fabric workspaces named Workspace1 and Workspace2. The company decides to implement a domain strategy to organize the...

QUESTION 25 You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1. You plan to add a user named User3 to Workspace1....

QUESTION 26 You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Micros...

QUESTION 27 You have two Fabric workspaces named Workspace1 and Workspace2. You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Worksp...

QUESTION 28 You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1. You have a deployment pipeline named deploy...

QUESTION 29 You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transf...

You have five Fabric workspaces. You are monitoring the execution of items by using Monitoring hub. You need to identify in which workspace specified item runs. Which column should...

You have a Fabric workspace that contains a lakehouse named Lakehouse1. In an external data source, you have data files that are 500 GB each. A new file is added every day. You nee...

You have a Fabric workspace that contains an eventhouse and a KQL database named Database1. Database1 has the following: - A table named Table1 - A table named Table2 - An update p...

You are developing a data pipeline named Pipeline1. You need to add a Copy data activity that will copy data from a Snowflake data source to a Fabric warehouse. What should you con...

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...

You have a KQL database that contains two tables named Stream and Reference. Stream contains streaming data in the following format: Column name Data type Timestamp Datetime Geoloc...

You have a KQL database that contains two tables named Stream and Reference. Stream contains streaming data in the following format: Column name Data type Timestamp Datetime Geoloc...

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1. You analyze Table1 and discover that Table1 contains 2,000 P...

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the da...

You have a Fabric workspace named Workspace1_DEV that contains the following items: - 10 reports - Four notebooks - Three lakehouses - Two data pipelines - Two Dataflow Gen1 datafl...

Given the following items: Name | Type ---|--- Notebook1 | Notebook Notebook2 | Notebook Lakehouse1 | Lakehouse Pipeline1 | Data pipeline Model1 | Semantic model Note: For Model1,...

You are implementing the following data entities in a Fabric environment: - Entity1: Available in a lakehouse and contains data that will be used as a core organization entry - Ent...

You have three users named User1, User2, and User3. You have the Fabric workspaces shown in the following table. Name | Workspace admin ---|--- Workspace1 | User1 Workspace2 | User...

Your company has a team of developers. The team creates Python libraries of reusable code that is used to transform data. You create a Fabric workspace name Workspace1 that will be...

You have a Fabric workspace that contains a warehouse named Warehouse1. In Warehouse1, you create a table named DimCustomer by running the following statement: CREATE TABLE dbo.Dim...

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following tables and columns: Table name | Column name | Data type ---|---|--- Emplo...

You have an Azure Event Hubs data source that contains weather data. You ingest the data from the data source by using an eventstream named Eventstream1. Eventstream1 uses a lakeho...

You have the following code segment: def loading_pattern_sample(df_source): try: deltatable = DeltaTable.forName(spark, target_table) except Exception as e: df_source.write.format(...

You have the following code segment: def loading_pattern_sample(df_source): try: deltatable = DeltaTable.forName(spark, target_table) except Exception as e: df_source.write.format(...

You have the following code segment: def loading_pattern_sample(df_source): try: deltatable = DeltaTable.forName(spark, target_table) except Exception as e: df_source.write.format(...

You have a Fabric workspace that contains two lakehouses named Lakehouse1 and Lakehouse2. Lakehouse1 contains staging data in a Delta table named Orderlines. Lakehouse2 contains a...

You have a Fabric workspace. You are debugging a statement and discover the following issues: - Sometimes, the statement fails to return all the expected rows. - The PurchaseDate o...

You have a Fabric eventhouse that contains an KQL database. The database contains a table named TaxiData. The following is a sample of the data in TaxiData. VendorID tpep_pickup_da...