📘 Free DP-700 Sample Questions
Case Study -
Overview. Company Overview -
Contoso, Ltd. is an online retail company that wants to modernize its analytics platform by moving to Fabric. The
company plans to begin using Fabric for marketing analytics.
Overview. IT Structure -
The company’s IT department has a team of data analysts and a team of data engineers that use analytics systems.
The data engineers perform the ingestion, transformation, and loading of data. They prefer to use Python or SQL to
transform the data.
The data analysts query data and create semantic models and reports. They are qualified to write queries in Power
Query and T-SQL.
Existing Environment. Fabric -
Contoso has an F64 capacity named Cap1. All Fabric users are allowed to create items.
Contoso has two workspaces named WorkspaceA and WorkspaceB that currently use Pro license mode.
Existing Environment. Source Systems
Contoso has a point of sale (POS) system named POS1 that uses an instance of SQL Server on Azure Virtual Machines
in the same Microsoft Entra tenant as Fabric. The host virtual machine is on a private virtual network that has public
access blocked. POS1 contains all the sales transactions that were processed on the company’s website.
The company has a software as a service (SaaS) online marketing app named MAR1. MAR1 has seven entities. The
entities contain data that relates to email open rates and interaction rates, as well as website interactions. The data
can be exported from MAR1 by calling REST APIs. Each entity has a different endpoint.
Contoso has been using MAR1 for one year. Data from prior years is stored in Parquet files in an Amazon Simple
Storage Service (Amazon S3) bucket. There are 12 files that range in size from 300 MB to 900 MB and relate to email
interactions.
Existing Environment. Product Data
POS1 contains a product list and related data. The data comes from the following three tables:
Products -
ProductCategories -
ProductSubcategories -
In the data, products are related to product subcategories, and subcategories are related to product categories.
Existing Environment. Azure -
Contoso has a Microsoft Entra tenant that has the following mail-enabled security groups:
DataAnalysts: Contains the data analysts
DataEngineers: Contains the data engineers
A
A. Add the DataAnalyst group to the Viewer role for WorkspaceA.
B
B. Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic
model permission.
C
C. Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission
D
D. Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.
Correct Answer:
C. C. Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission
You have a Fabric workspace.
You have semi-structured data.
You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark.
What should you use to store the data?
A
A. a lakehouse
B
B. an eventhouse
C
C. a datamart
D
D. a warehouse
Correct Answer:
B. B. an eventhouse
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-premises
data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?
A
A. a Dataflow Gen1 dataflow
B
B. a data pipeline
C
C. a KQL queryset
D
D. a notebook
Correct Answer:
B. B. a data pipeline
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-premises
data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?
A
A. an Apache Spark job definition
B
B. a data pipeline
C
C. a Dataflow Gen1 dataflow
D
D. an eventstream
Correct Answer:
B. B. a data pipeline
You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is
modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?
A
A. Change the MD5 hash to SHA256.
B
B. Increase the capacity.
C
C. Enable V-Order.
D
D. Modify the surrogate keys to use a different data type.
Correct Answer:
C. C. Enable V-Order.
HOTSPOT -
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and
columns
A
Correct answer - A
Correct Answer:
A. Correct answer - A
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.
A
A. Date
B
B. ProductName
C
C. ProductColor
D
D. TransactionID
E
E. SalesAmount
F
F. ProductID
Correct Answer:
B. B. ProductName
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 attach Notebook2 to the same Apache Spark session as Notebook1.
What should you do?
A
A. Enable high concurrency for notebooks
B
B. Enable dynamic allocation for the Spark pool.
C
C. Change the runtime version.
D
D. Increase the number of executors.
Correct Answer:
A. A. Enable high concurrency for notebooks
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1
contains the following tables:
Orders -
Customer -
Employee -
The Employee table contains Personally Identifiable Information (PII).
A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT
have the elevated permissions required to view the contents of the Employee table.
You need to ensure that the data engineer can write data to the Customer table without reading data from the
Employee table.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A
A. Share Lakehouse1 with the data engineer.
B
B. Assign the data engineer the Contributor role for Workspace2
C
C. Assign the data engineer the Viewer role for Workspace2
D
D. Assign the data engineer the Contributor role for Workspace1
E
E. Migrate the Employee table from Lakehouse1 to Lakehouse2
F
F. Create a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.
Correct Answer:
D. D. Assign the data engineer the Contributor role for Workspace1
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).
You need to ensure that the sales representatives can see only their respective data.
Which warehouse object do you require to implement RLS?
A
A. STORED PROCEDURE
B
B. CONSTRAINT
C
C. SCHEMA
D
D. FUNCTION
Correct Answer:
D. D. FUNCTION
Questions: 1-10 out of 141
Continue Full Practice..
GET ALL 141 QUESTIONS