Test
DP-700
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (99)
1You need to ensure that the data analysts can access the gold layer lakehouse.
What should you do?- AAdd the DataAnalyst group to the Viewer role for WorkspaceA.
- BShare the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
- CShare the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.
- DShare the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.
2You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements.
What should you do?- ACreate a workspace identity and enable high concurrency for the notebooks.
- BCreate a shortcut and ensure that caching is disabled for the workspace.
- CCreate a workspace identity and use the identity in a data pipeline.
- DCreate a shortcut and ensure that caching is enabled for the workspace.
3You need to implement the solution for the book reviews.
Which should you do?- ACreate a Dataflow Gen2 dataflow.
- BCreate a shortcut.
- CEnable external data sharing.
- DCreate a data pipeline.
4You need to resolve the sales data issue. The solution must minimize the amount of data transferred.
What should you do?- ASpilt the dataflow into two dataflows.
- BConfigure scheduled refresh for the dataflow.
- CConfigure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.
- DConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.
- EConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.
5You 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?- Aa lakehouse
- Ban eventhouse
- Ca datamart
- Da warehouse
6You 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?- Aa Dataflow Gen1 dataflow
- Ba data pipeline
- Ca KQL queryset
- Da notebook
7You 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?- Aan Apache Spark job definition
- Ba data pipeline
- Ca Dataflow Gen1 dataflow
- Dan eventstream
8You 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?- AChange the MD5 hash to SHA256.
- BIncrease the capacity.
- CEnable V-Order
- DModify the surrogate keys to use a different data type.
- ECreate views.
9You 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.
You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.- ADate
- BProductName
- CProductColor
- DTransactionID
- ESalesAmount
- FProductID
10You 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?- AEnable high concurrency for notebooks.
- BEnable dynamic allocation for the Spark pool.
- CChange the runtime version.
- DIncrease the number of executors.
11HOTSPOT
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers.
What should you recommend for each layer? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ABronze layer: A Dataflow Gen2 dataflow
- BBronze layer: A notebook
- CBronze layer: A pipeline Copy activity
- DBronze layer: A pipeline stored procedure
- ESilver layer: A Dataflow Gen2 dataflow
- FSilver layer: A notebook
- GSilver layer: A pipeline Copy activity
- HSilver layer: A pipeline stored procedure
12You need to populate the MAR1 data in the bronze layer.
Which two types of activities should you include in the pipeline? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.- AForEach
- BCopy data
- CWebHook
- DStored procedure
13HOTSPOT
You need to troubleshoot the ad-hoc query issue.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- Aqueryinsights.exec_requests_history
- Bqueryinsights.exec_sessions_history
- Cqueryinsights.frequently_run_queries
- Dqueryinsights.long_running_queries
- Emax_run_total_elapsed_time_ms > 7200000
- Fmedian_total_elapsed_time_ms > 7200000
- Gnumber_of_canceled_runs > 1
- Hnumber_of_failed_runs > 1
- Inumber_of_runs > 1
14HOTSPOT
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following
tables and columns.
You need to create an output that presents the summarized values of all the order quantities by year and product. The results must include a summary of the order quantities at the year level for all the products.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ASELECT CAST
- BSELECT CONVERT
- CSELECT YEAR
- DCUBE(YEAR(SO.ModifiedDate), P.Name)
- EGROUPING SETS ((YEAR(SO.ModifiedDate), P.Name), (YEAR(SO.ModifiedDate)))
- FROLLUP(YER(SO.ModifiedDate), P.Name)
- GYEAR(SO.ModifiedDate), P.Name
15HOTSPOT
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.
NOTE: Each correct selection is worth one point.
- ACategoryID = 1;
- B1. INNER JOIN
- CCategoryName is not null;
- DIsActive = 1;
- EIsActive is not null;
- FProductNumber is not null;
- G2. INNER JOIN
- HSubCategoryID = 1;
- ISubCategoryName is not null;
16HOTSPOT
You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.
You need to create an output that presents the summarized values of all the order quantities by year and product. The results must include a summary of the order quantities at the year level for all the products.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ASELECT CAST
- BSELECT CONVERT
- CSELECT YEAR
- DCUBE(YEAR(SO.ModifiedDate), P.Name)
- EGROUPING SETS ((YEAR(SO.ModifiedDate), P.Name), (YEAR(SO.ModifiedDate)))
- FROLLUP(YEAR(SO.ModifiedDate), P.Name)
- GYEAR(SO.ModifiedDate), P.Name
17You 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.
You plan to load the data into a dimensional model and implement a star schem
a. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.- ADate
- BProductName
- CProductColor
- DTransactionID
- ESalesAmount
- FProductID
18You 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?- AEnable high concurrency for notebooks.
- BEnable dynamic allocation for the Spark pool.
- CChange the runtime version.
- DIncrease the number of executors.
19You 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.- AShare Lakehouse1 with the data engineer.
- BAssign the data engineer the Contributor role for Workspace2.
- CAssign the data engineer the Viewer role for Workspace2.
- DAssign the data engineer the Contributor role for Workspace1.
- EMigrate the Employee table from Lakehouse1 to Lakehouse2.
- FCreate a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.
- GAssign the data engineer the Viewer role for Workspace1.
20You 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?- AISTORED PROCEDURE
- BCONSTRAINT
- CSCHEMA
- DFUNCTION
21HOTSPOT
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 dataflows
Three Dataflow Gen2 dataflows
Five semantic models that each has a scheduled refresh policy
You create a deployment pipeline named Pipeline1 to move items from Workspace1_DEV to a new
workspace named Workspace1_TEST.
You deploy all the items from Workspace1_DEV to Workspace1_TEST.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.- AData from the semantic models will be deployed to the target stage. Yes
- BData from the semantic models will be deployed to the target stage. No
- CThe Dataflow Gen1 dataflows will be deployed to the target stage. Yes
- DThe Dataflow Gen1 dataflows will be deployed to the target stage. No
- EThe scheduled refresh policies will be deployed to the target stage. Yes
- FThe scheduled refresh policies will be deployed to the target stage. No
22You 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 to add the eventhouse to the deployment process?- AGitHub Actions
- Ba deployment pipeline
- Can Azure DevOps pipeline
23You 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 deployment process, you need to verify whether Warehouse1 contains invalid
references. The solution must minimize development effort.
What should you use?- Aa database project
- Ba deployment pipeline
- Ca Python script
- Da T-SQL script
24You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?- AYou have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake? - Bonly the existing data in the eventhouse
- Cno data
- Dboth new data and existing data in the eventhouse
- Eonly new data added to the eventhouse
- AYou have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
25You 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 from Workspace1
to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1
by using an API call from an Azure DevOps pipeline.
You need to configure API authentication between Azure DevOps and Fabric.
Which type of authentication should you use?- Aservice principal
- BMicrosoft Entra username and password
- Cmanaged private endpoint
- Dworkspace identity
26You have a Google Cloud Storage (GCS) container named storage1 that contains the files shown in
the following table.
You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled.
Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the shortcuts shown in the
following table.
You need to read data from all the shortcuts.
Which shortcuts will retrieve data from the cache?- AStores only
- BProducts only
- CStores and Products only
- DProducts, Stores, and Trips
- ETrips only
- FProducts and Tripcs only
27You 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 internet access disabled.
You need to ensure that Job1 can access the data in Source1.
What should you create?- Aan on-premises data gateway
- Ba managed private endpoint
- Can integration runtime
- Da data management gateway
28You 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.
You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled.
Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts:
A shortcut to ProductFile aliased as Products
A shortcut to StoreFile aliased as Stores
A shortcut to TripsFile aliased as Trips
The data from which shortcuts will be retrieved from the cache?- ATrips and Stores only
- BProducts and Store only
- CStores only
- DProducts only
- EProducts. Stores, and Trips
29HOTSPOT
You have a Fabric workspace named Workspace1 that contains the items shown in the following table.
For Model1, the Keep your Direct Lake data up to date option is disabled.
You need to configure the execution of the items to meet the following requirements:
Notebook1 must execute every weekday at 8:00 AM.
Notebook2 must execute when a file is saved to an Azure Blob Storage container.
Model1 must refresh when Notebook1 has executed successfully.
How should you orchestrate each item? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ANotebook1: Add Notebook1 to Pipeline1.
- BNotebook2: From Real-Time hub, configure the execution of Notebook2.
- CPipeline1:Configure the execution of Pipeline1 by using a schedule.
- DModel1: Add Model1 to Pipeline1.
30Your 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 workspaces.
You need to ensure that a user can perform the following tasks:
Create a new domain for the sales department.
Create two subdomains: one for the east region and one for the west region.
Assign Workspace1 to the east region subdomain.
Assign Workspace2 to the west region subdomain.
The solution must follow the principle of least privilege.
Which role should you assign to the user?- Aworkspace Admin
- Bdomain admin
- Cdomain contributor
- DFabric admin
31You 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.
You need to ensure that User3 can perform the following actions:
View all the items in Workspace1.
Update the tables in DW1.
The solution must follow the principle of least privilege.
You already assigned the appropriate object-level permissions to DW1.
Which workspace role should you assign to User3?- AAdmin
- BMember
- CViewer
- DContributor
32You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a
lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?- AShare Lakehouse1 with User1 directly and select Read all SQL endpoint data.
- BAssign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.
- CShare Lakehouse1 with User1 directly and select Build reports on the default semantic model.
- DAssign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.
33Entity1: Available in a lakehouse and contains data that will be used as a core organization entity
Entity2: Available in a semantic model and contains data that meets organizational standards
Entity3: Available in a Microsoft Power BI report and contains data that is ready for sharing and reuse
Entity4: Available in a Power BI dashboard and contains approved data for executive-level decision
making
Your company requires that specific governance processes be implemented for the data.
You need to apply endorsement badges to the entities based on each entity’s use case.
Which badge should you apply to each entity? To answer, drag the appropriate badges the correct
entities. Each badge may be used once, more than once, or not at all. You may need to drag the split
bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point
- AEntity1: Master data
- BEntity2: Certified
- CEntity3: Promoted
- DEntity4: Certified
34HOTSPOT
You have three users named User1, User2, and User3.
You have the Fabric workspaces shown in the following table.
You have a security group named Group1 that contains User1 and User3.
The Fabric admin creates the domains shown in the following table.
User1 creates a new workspace named Workspace3.
You add Group1 to the default domain of Domain1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.- AUser3 has Viewer role access to Workspace3. Yes
- BUser3 has Viewer role access to Workspace3. No
- CUser3 has Domain contributor access to Domain1. Yes
- DUser3 has Domain contributor access to Domain1. No
- EUser2 has Contributor role access to Workspace3. Yes
- FUser2 has Contributor role access to Workspace3. No
35You have two Fabric workspaces named Workspace1 and Workspace2.
You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1
to Workspace2. DeployPipeline1 contains all the items in Workspace1.
You recently modified the items in Workspaces1.
The workspaces currently contain the items shown in the following table.
Items in Workspace1 that have the same name as items in Workspace2 are currently paired.
You need to ensure that the items in Workspace1 overwrite the corresponding items in Workspace2.
The solution must minimize effort.
What should you do?- ADelete all the items in Workspace2, and then run deployPipeline1.
- BRename each item in Workspace2 to have the same name as the items in Workspace1.
- CBack up the items in Workspace2, and then run deployPipeline1.
- DRun deployPipeline1 without modifying the items in Workspace2.
36You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and
a lakehouse named Lakehouse1.
You have a deployment pipeline named deployPipeline1 that deploys Workspace1 to Workspace2.
You restructure Workspace1 by adding a folder named Folder1 and moving Pipeline1 to Folder1.
You use deployPipeline1 to deploy Workspace1 to Workspace2.
What occurs to Workspace2?- AFolder1 is created, Pipeline1 moves to Folder1, and Lakehouse1 is deployed.
- BOnly Pipeline1 and Lakehouse1 are deployed.
- CFolder1 is created, and Pipeline1 and Lakehouse1 move to Folder1.
- DOnly Folder1 is created and Pipeline1 moves to Folder1.
37DRAG DROP
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 used to develop extract, transform, and
load (ETL) solutions by using notebooks.
You need to ensure that the libraries are available by default to new notebooks in Workspace1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.
- A1. Create an environment.
- B2. Install the libraries.
- C3. Set the default environment.
38You 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 transformation logic.
The data from the DataFrame is then written to a new Delta table named Table2 by using a merge
operation.
You need to consolidate the underlying Parquet files in Table1.
Which command should you run?- AVACUUM
- BBROADCAST
- COPTIMIZE
- DCACHE
39You have five Fabric workspaces.
You are monitoring the execution of items by using Monitoring hub.
You need to identify in which workspace a specific item runs.
Which column should you view in Monitoring hub?- AStart time
- BCapacity
- CActivity name
- DSubmitter
- EItem type
- FJob type
- GLocation
40You 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 Notebook1 was executed.
What should you use?- AReal-Time hub
- BOneLake data hub
- Cthe Admin monitoring workspace
- DFabric Monitor
- Ethe Microsoft Fabric Capacity Metrics app
41DRAG DROP
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.DimCustomer(
CustomerKey VARCHAR(255) NOT NULL,
Name VARCHAR(255) NOT NULL,
Email VARCHAR(255) NOT NULL
);
You need to set the Customerkey column as a primary key of the DimCustomer table.
Which three code segments should you run in sequence? To answer, move the appropriate code
segments from the list of code segments to the answer area and arrange them in the correct order.
- A1. ALTER TABLE dbo.DimCustomer
- B2. ADD CONSTRAINT PK_DimCustomer PRIMARY KEY CLUSTERED (CustomerKey)
- C3. ENFORCED
42You 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?- Adynamic management views in Microsoft SQL Server Management Studio
- BMonitoring hub
- Cdynamic management views in Azure Data Studio
- Da semantic link in a notebook
43Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database.
The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution
must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results
must be ordered by No_Bikes in ascending order.
Does this meet the goal?
- AYes
- BNo
44Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database.
The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution
must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results
must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:
Does this meet the goal?
- AYes
- BNo
45Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database.
The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution
must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results
must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:
Does this meet the goal?
- AYes
- BNo
46Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database.
The table contains the following columns:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
Timestamp
You need to apply transformation and filter logic to prepare the data for consumption. The solution
must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results
must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:
Does this meet the goal?
- AYes
- BNo
47HOTSPOT
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains
the following tables and columns
You need to denormalize the tables and include the ContractType and StartDate columns in the
Employee table. The solution must meet the following requirements:
Ensure that the StartDate column is of the date data type.
Ensure that all the rows from the Employee table are preserved and include any matching rows from
the Contract table.
Ensure that the result set displays the total number of employees per contract type for all the
contract types that have more than two employees.
How should you complete the statement? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- A1. CAST
- B2. LEFT OUTER JOIN
- C3. HAVING
48HOTSPOT
HOTSPOT
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 lakehouse as the destination.
You need to batch ingest only rows from the data source where the City attribute has a value of
Kansas. The filter must be added before the destination. The solution must minimize development
effort.
What should you use for the data processor and filtering? To answer, select the appropriate options
in the answer area.
NOTE: Each correct selection is worth one point.
- AData processor: A Dataflow Gen2 dataflow
- BFiltering: A filter in a Dataflow Gen2 dataflow
49You 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 data in a
lakehouse.
You need to modify Eventstream1 to include the standard deviation of the temperature.
Which transform operator should you include in the Eventstream1 logic?- AExpand
- BGroup by
- CUnion
- DAggregate
50You 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 the events. The solution must only retain events that have a Neighbourhood value
of Chelsea, and then store the retained events in a Fabric lakehouse.
What should you use?- Aa KQL queryset
- Ban eventstream
- Ca streaming dataset
- DApache Spark Structured Streaming
51You are building a data loading pattern for Fabric notebook workloads.
You have the following code segment:
- AThe target table will always be oerwritten. Yes
- BThe target table will always be oerwritten. No
- CThe merge operation will always run. Yes
- DThe merge operation will always run. No
- EThe loading patter supports both full and incremental loading requirements. Yes
- FThe loading patter supports both full and incremental loading requirements. No
52HOTSPOT
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 Type 2
slowly changing dimension (SCD) dimension table named Dim_Customer.
You need to build a query that will combine data from Orderlines and Dim_Customer to create a new
fact table named Fact_Orders. The new table must meet the following requirements:
Enable the analysis of customer orders based on historical attributes.
Enable the analysis of customer orders based on the current attributes.
How should you complete the statement? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- A(1) o.OrderDate >= c.valid_from_datetime t
- B(2) o.OrderDate < c.valid_to_datetime
53You 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 need to ingest the data into Lakehouse1 without applying any transformations. The solution
must meet the following requirements
Trigger the process when a new file is added.
Provide the highest throughput.
Which type of item should you use to ingest the data?- AEvent stream
- BDataflow Gen2
- CStreaming dataset
- DData pipeline
54You 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 need to ingest the data into Lakehouse1 without applying any transformations. The solution
must meet the following requirements
Trigger the process when a new file is added.
Provide the highest throughput.
Which type of item should you use to ingest the data?- AData pipeline
- BEnvironment
- CKQL queryset
- DDataflow Gen2
55You 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 policy named Policy1
Policy1 sends data from Table1 to Table2.
The following is a sample of the data in Table2.
Recently, the following actions were performed on Table1:
An additional element named temperature was added to the StreamData column.
The data type of the Timestamp column was changed to date.
The data type of the DeviceId column was changed to string.
You plan to load additional records to Table2.
Which two records will load from Table1 to Table2? Each correct answer presents a complete
solution.
- AOption A
- BOption B
- COption C
- DOption D
56HOTSPOT
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 output column is NOT in the expected format of mmm dd, yy.
You need to resolve the issues. The solution must ensure that the data types of the results are
retained. The results can contain blank cells.
How should you complete the statement? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point
- A(1), try_cast(item_name as varchar(20))
- B(2),convert(varchar, purchase_date, 7)
57You 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 configure?- ADegree of copy parallelism
- BFault tolerance
- CEnable staging
- DEnable logging
58Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains
streaming data in the following formatº
Both tables contain millions of rows.
You have the following KQL queryset.
You need to reduce how long it takes to run the KQL queryset.
Solution: You change the join type to kind=outer.
Does this meet the goal?
- AYes
- BNo
59Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains
streaming data in the following format.
Both tables contain millions of rows.
You have the following KQL queryset.
You need to reduce how long it takes to run the KQL queryset.
Solution: You change project to extend.
Does this meet the goal?
- AYes
- BNo
60Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains
streaming data in the following format.
Both tables contain millions of rows.
You have the following KQL queryset.
You need to reduce how long it takes to run the KQL queryset.
Solution: You move the filter to line 02.
Does this meet the goal?
- AYes
- BNo
61Note: 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 question sets might
have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains
streaming data in the following format.
Both tables contain millions of rows.
You have the following KQL queryset.
You need to reduce how long it takes to run the KQL queryset.
Solution: You add the make_list() function to the output columns.
Does this meet the goal?
- AYes
- BNo
62You have a Fabric eventhouse that contains a KQL database. The database contains a table named
TaxiDat
a. The following is a sample of the data in TaxiData
You need to build two KQL queries. The solution must meet the following requirements:
One of the queries must partition RunningTotalAmount by VendorID.
The other query must create a column named FirstPickupDateTime that shows the first value of each hour from tpep_pickup_datetime partitioned by payment_type.
How should you complete each query? To answer, drag the appropriate values the correct targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
- A(1) Row_cumsum
- B(2) Row_window_session
63HOTSPOT
You are processing streaming data from an external data provider.
You have the following code segment.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- ALitware from New Yorl will be displayed at the top of the result set. Yes
- BLitware from New Yorl will be displayed at the top of the result set. No
- CFabrikam in Seattle will have value = 2 in the Rank column. Yes
- DFabrikam in Seattle will have value = 2 in the Rank column. No
- ELitware in San Francisco will have the same value in the Rank column as Litware in New York. Yes
- FLitware in San Francisco will have the same value in the Rank column as Litware in New York. No
64You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains Delta table named Table1.
You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1 MB each.
You need to minimize how long it takes to query Table1.
What should you do?- ADisable V-Order and run the OPTIMIZE command
- BDisable V-Order and run the VACCUM command
- CRun the OPTIMIZE and VACUUM commands
65You 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 daily data load takes longer than expected.
You need to monitor Warehouse1 to identify the names of users that are actively running queries.
Which view should you use?- Asys.dm_exec_connections
- Bsys.dm_exec_requests
- Cqueryinsights.long_running_queries
- Dqueryinsights.frequently_run_queries
- Esys.dm_exec_sessions
66You 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 seven days and are no longer in use.
Which command should you run?- AVACCUM
- BCOMPUTE
- COPTIMIZE
- DCLONE
67You 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 scheduled to run every
15 minutes.
You discover that Pipeline1 keeps failing.
You need to identify which SQL query was executed when the pipeline failed.
What should you do?- AFrom Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
- BFrom Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON
- CFrom Real-time hub, select Fabric events, and then review the details of
Microsoft.Fabric.ItemReadFailed. - DFrom Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.ItemUpdateFailed.
68You have a Fabric notebook named Notebook1 that has been executing successfully for the last
week.
During the last run, Notebook1executed nine jobs.
You need to view the jobs in a timeline chart.
What should you use?- AReal-Time hub
- BMonitoring hub
- Cthe job history from the application run
- DSpark History Server
- Ethe run series from the details of the application run
69HOTSPOT
You have a Fabric workspace that contains an eventstream named EventStream1.
You discover that an EventStream1 transformation fails.
You need to find the following error information:
The error details, including the occurrence time
The total number of errors
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- A(1) Runtime logs
- B(2) Details
70HOTSPOT
You have a Fabric warehouse named DW1 that contains four staging tables named ProductCategory,
ProductSubcategory, Product, and SalesOrder. ProductCategory, ProductSubcategory, and Product
are used often in analytical queries.
You need to implement a star schema for DW1. The solution must minimize development effort.
Which design approach should you use? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- ADenormalized into a single product dimension table
- BThe product category name
71DRAG DROP
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_salesperson.
Load.Orders writes to a Delta table named fact_orders and is dependent on the successful execution
of Load_Salesperson.
You need to implement a pattern to dynamically execute Load_Salesperson and Load_Orders in the
appropriate order by using a notebook.
How should you complete the code? To answer, drag the appropriate values the correct targets. Each
value may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.
NOTE: Each correct selection is worth one point.
- Aactivities
- Bbroadcast
- Cdependencies
- Dexecute
- Enotebooks
- FrunMultiple
72HOTSPOT
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 members who currently use Microsoft Power BI. The team wants to transform
data by using by a low-code approach.
• Team2 consists of members that have a background in Python programming. The team wants to
use PySpark code to transform data.
• Team3 consists of members who currently use Azure Data Factory. The team wants to move data
between source and sink environments by using the least amount of effort.
You need to recommend tools for the teams based on their current personas.
What should you recommend for each team? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- ATeam1: Dataflow Gen2 dataflows
- BTeam2: Notebooks
- CTeam3: Data pipelines
73HOTSPOT
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 the
following statement.
CREATE TABLE [warehouse2].[dbo].[CreditCard]
{
CreditCard varchar(20) NOT NULL
, CreditCardType varchar(10) NOT NULL)
GO
You need to ensure that the team can view only the first two characters and the last four characters
of the Creditcard attribute.
How should you complete the statement? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- AALTER
- BALTER_2
- CPARTIAL
74HOTSPOT
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.)
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 expression? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
- ALookup Schema and Table
- Boutput.value
75HOTSPOT
You have a Fabric workspace that contains a warehouse named Warehouse!. Warehousel contains a
table named DimCustomers. DimCustomers contains the following columns:
• CustomerName
• CustomerlD
• BirthDate
• Email
You need to configure security to meet the following requirements:
• BirthDate in DimCustomer must be masked and display 1900-01-01.
• Email in DimCustomer must be masked and display only the first leading character and the last
five characters.
How should you complete the statement? To answer, select the appropriate options in the answer
are
a. NOTE: Each correct selection is worth one point.
- A'default()'
- B'partial(1900-01-01)'
- C'random(1900-01-01, 1900-01-01)'
- D'default()'_2
- E'email()'
- F'partial(1,"@",5)'
- G'random(1,"@", 5)'
76You have a Fabric workspace named Workspacel that contains the following items:
• A Microsoft Power Bl report named Reportl
• A Power Bl dashboard named Dashboardl
• A semantic model named Modell
• A lakehouse name Lakehouse1
Your company requires that specific governance processes be implemented for the items. Which
items can you endorse in Fabric?- ALakehouse1, Modell, and Dashboard1 only
- BLakehouse1, Modell, Report1 and Dashboard1
- CReport1 and Dashboard1 only
- DModel1, Report1, and Dashboard1 only
- ELakehouse1, Model1, and Report1 only
77You have a Fabric workspace that contains a warehouse named Warehouse1.
While monitoring Warehouse1, you discover that query performance has degraded during the last 60
minutes.
You need to isolate all the queries that were run during the last 60 minutes. The results must include
the username of the users that submitted the queries and the query statements. What should you
use?- Athe Microsoft Fabric Capacity Metrics app
- Bviews from the queryinsights schema
- CQuery activity
- Dthe sys.dm_exec_requests dynamic management view
78You have a Fabric workspace that contains a semantic model named Modell. You need to monitor the
refresh history of Model 1 and visualize the refresh history in a chart. What should you use?- Athe refresh history from the settings of Model1.
- Ba notebook
- Ca Dataflow Gen2 dataflow
- Da data pipeline
79HOTSPOT
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 destination. The unique primary key will be an integer and will start from 1 and have
an increment of 1.
• Dataset2: This dataset contains semi-structured data that uses bulk data transfer. The dataset must
be handled in one process between the source and the destination. The data transformation process
will include the use of custom visuals to understand and work with the dataset in development
mode.
• Dataset3. This dataset is in a takehouse. The data will be bulk loaded. The data transformation
process will include row-based windowing functions during the loading process.
You need to identify which type of item to use for the datasets. The solution must minimize
development effort and use built-in functionality, when possible. What should you identify for each
dataset? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ADataset1: A T-SQL statement
- BDataset2: A notebook
- CDataset3: A KQL queryset
80HOTSPOT
You have a Fabric workspace that contains a lakehouse named Lakehousel. Lakehousel contains a
table named Status_Target that has the following columns:
• Key
• Status
• LastModified
The data source contains a table named Status.Source that has the same columns as Status_Target.
Status.Source is used to populate Status_Target. In a notebook name Notebook!, you load
Status_Source to a DataFrame named sourceDF and Status_Target to a DataFrame named targetDF.
You need to implement an incremental loading pattern by using Notebook-!. The solution must meet
the following requirements:
• For all the matching records that have the same value of key, update the value of LastModified in
Status_Target to the value of LastModified in Status_Source.
• Insert all the records that exist in Status_Source that do NOT exist in Status_Target.
• Set the value of Status in Status_Target to inactive for all the records that were last modified more
than seven days ago and that do NOT exist in Status.Source.
How should you complete the statement? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
- A.whenMatchedUpdate(
- B.whenNotMatchedInsert(
- C.whenNotMatchedBySourceUpdate(
81DRAG DROP
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, you create a control table named Control.Object as shown in the exhibit. (Click the
Exhibit tab.)
You need to build a data pipeline that will support the dynamic ingestion of the tables listed in the
control table by using a single execution.
Which three actions should you perform in sequence? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.- AAdd a Lookup activity to query Control Object and generate a list of the schemas and tables to copy.
- BAdd ForEach activity to iterate over the list of tables and copy the source data to the lakehouse Delta tables.
- CAdd a Copy data activity as an inner activity to the iterator activity.
- DAdd Get metadata activity to query Control.Object and generate a list of schemas and tables to copy.
- EAdd an Until activity to iterate over the list of tables and copy the source data to the lakehouse Delta tables.
82You are implementing a medallion architecture in a Fabric lakehouse.
You plan to create a dimension table that will contain the following columns:
• ID
• CustomerCode
• CustomerName
• CustomerAddress
• CustomerLocation
• ValidFrom
• ValidTo
You need to ensure that the table supports the analysis of historical sales data by customer location
at the time of each sale Which type of slowly changing dimension (SCD) should you use?- AType 2
- BType 0
- CType 1
- DType 3
83You have a Fabric workspace that contains an eventstream named EventStreaml. EventStreaml
outputs events to a table named Tablel in a lakehouse. The streaming data is souiced from motorway
sensors and represents the speed of cars.
You need to add a transformation to EventStream1 to average the car speeds. The speeds must be
grouped by non-overlapping and contiguous time intervals of one minute. Each event must belong to
exactly one window.
Which windowing function should you use?- Asliding
- Bhopping
- Ctumbling
- Dsession
84HOTSPOT
You have a table in a Fabric lakehouse that contains the following data.- ALine 01 will replace all the null and empty values in the CustomerName column with the Unknown value. Yes
- BLine 01 will replace all the null and empty values in the CustomerName column with the Unknown value. No
- CLine 02 will extract the value before the @ character and generate a new column named Username. Yes
- DLine 02 will extract the value before the @ character and generate a new column named Username. No
- ELine 03 will extract the year value from the OrderDate column and keep only the first ocurrence for each year. Yes
- FLine 03 will extract the year value from the OrderDate column and keep only the first ocurrence for each year. No
85You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses.
You need to configure source control for Workpace1 to use GitHub. The solution must follow the
principle of least privilege. Which permissions do you require to ensure that you can commit code to
GitHub?- AActions (Read and write) and Contents (Read and write)
- BActions (Read and write) only
- CContents (Read and write) only
- DContents (Read) and Commit statuses (Read and write)
86You have an Azure key vault named KeyVaultl that contains secrets.
You have a Fabric workspace named Workspace-!. Workspace! contains a notebook named
Notebookl that performs the following tasks:
• Loads stage data to the target tables in a lakehouse
• Triggers the refresh of a semantic model
You plan to add functionality to Notebookl that will use the Fabric API to monitor the semantic
model refreshes. You need to retrieve the registered application ID and secret from KeyVaultl to
generate the authentication token.
Solution: You use the following code segment:
Use notebookutils.credentials.getSecret and specify the key vault URL and key vault secret. Does this
meet the goal?- AYes
- BNo
87You have an Azure key vault named KeyVaultl that contains secrets.
You have a Fabric workspace named Workspace!. Workspace! contains a notebook named Notebookl
that performs the following tasks:
• Loads stage data to the target tables in a lakehouse
• Triggers the refresh of a semantic model
You plan to add functionality to Notebookl that will use the Fabric API to monitor the semantic
model refreshes. You need to retrieve the registered application ID and secret from KeyVaultl to
generate the authentication token. Solution: You use the following code segment:
Use notebookutils. credentials.getSecret and specify key vault URL and the name of a linked service.
Does this meet the goal?- AYes
- BNo
88You need to develop an orchestration solution in fabric that will load each item one after the other.
The solution must be scheduled to run every 15 minutes. Which type of item should you use?- Awarehouse
- Bdata pipeline
- CDataflow Gen2 dataflow
- Dnotebook
89You have a Fabric workspace that contains a lakehouse named Lakehousel.
You plan to create a data pipeline named Pipeline! to ingest data into Lakehousel. You will use a
parameter named paraml to pass an external value into Pipeline1!. The paraml parameter has a data
type of int
You need to ensure that the pipeline expression returns param1 as an int value.
How should you specify the parameter value?- A"@pipeline(). parameters. paraml"
- B"@{pipeline().parameters.paraml}"
- C"@{pipeline().parameters.[paraml]}"
- D"@{pipeline().parameters.paraml}-
90You have a Fabric workspace that contains a takehouse and a semantic model named Model1.
You use a notebook named Notebook1 to ingest and transform data from an external data source.
You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet
the following requirements:
• Run daily at 07:00 AM UTC.
• Attempt to retry Notebook1 twice if the notebook fails.
• After Notebook1 executes successfully, refresh Model1.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE:
Each correct selection is worth one point.- ASet the Retry setting of the Notebook activity to 2.
- BPlace the Semantic model refresh activity after the Notebook activity and link the activities by using an On completion condition.
- CPlace the Semantic model refresh activity after the Notebook activity and link the activities by using the On success condition.
- DFrom the Schedule settings of Notebook1, set the time zone to UTC.
- EFrom the Schedule settings of Pipeline1, set the time zone to UTC.
- FSet the Retry setting of the Semantic model refresh activity to 2.
91HOTSPOT
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse! contains a table named Customer. Customer contains the following data
You have an internal Microsoft Entra user named User1 that has an email address of user1@contoso.com.
You need to provide User1 with access to the Customer table. The solution must prevent User1 from
accessing the CreditCard column.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- AALTER
- BEXECUTE
- CREAD
- DSELECT
- EVIEW
- FUser1
- G[User1]
- H[user1@contoso.com]
92You have a Fabric workspace that contains a write-intensive warehouse named DW1. DW1 stores
staging tables that are used to load a dimensional model. The tables are often read once, dropped,
and then recreated to process new data.
You need to minimize the load time of DW1.
What should you do?
- ADisable V-Order
- BDrop statistics
- CEnable V-O-der
- DCreate statistics
93You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit. (Click the Exhibit tab.) What will occur the next time Pipelinel tuns?
- ABoth activities will run simultaneously.
- BBoth activities will be skipped.
- CExecute procedurel will run and Copy_kdi will be skipped.
- DCopy.kdi will run and Execute procedurel will be skipped.
- EExecute procedure1 will run first, and then Copy_kdi will run.
- FCopy.kdi will run first, and then Execute procedurel will run.
94You are building a Fabric notebook named MasterNotebookl in a workspace. MasterNotebookl
contains the following code.
You need to ensure that the notebooks are executed in the following sequence:
1. Notebook_03
2. Notebook.Ol
3. Notebook_02
Which two actions should you perform? Each correct answer presents part of the solution. NOTE:
Each correct selection is worth one point.- ASplit the Directed Acyclic Graph (DAG) definition into three separate definitions.
- BChange the concurrency to 3.
- CMove the declaration of Notebook_03 to the top of the Directed Acyclic Graph (DAG) definition.
- DMove the declaration of Notebook_02 to the bottom of the Directed Acyclic Graph (DAG) definition.
- EAdd dependencies to the execution of Note boo k_02.
- FAdd dependencies to the execution of Notebook_03.
95HOTSPOT
You need to recommend a Fabric streaming solution that will use the sources shown in the following table.
The solution must minimize development effort.
What should you include in the recommendation for each source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- ASource1: A streaming dataflow
- BSource2: A data pipeline
- CSource3: An eventstream
96You have an Azure SQL database named DB1.
In a Fabric workspace, you deploy an eventstream named EventStreamDBI to stream record changes
from DB1 into a lakehouse.
You discover that events are NOT being propagated to EventStreamDBI.
You need to ensure that the events are propagated to EventStreamDBI.
What should you do?- ACreate a read-only replica of DB1.
- BCreate an Azure Stream Analytics job.
- CEnable Extended Events for DB1.
- DEnable change data capture (CDC) for DB1.
97You 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. The
columns are of various data types, including int, varchar, date, and varbinary.
You need to identify incoming changes to the table and update the records when there is a change.
The solution must minimize resource consumption.
What should you use to identify changes to attributes?- Aa direct attributes comparison for the attributes in the source table.
- Ba hash function to compare the attributes in the DimCustomer table.
- Ca direct attributes comparison across the attributes in the DimCustomer table.
- Da hash function to compare the attributes in the source table.
98You have a Fabric workspace named Workspace1.
You plan to configure Git integration for Workspacel by using an Azure DevOps Git repository. An
Azure DevOps admin creates the required artifacts to support the integration of Workspacel Which
details do you require to perform the integration?- Athe project, Git repository, branch, and Git folder
- Bthe organization, project. Git repository, and branch
- Cthe Git repository URL and the Git folder
- Dthe personal access token (PAT) for Git authentication and the Git repository URL
99You 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. Which option from the Settings tab of the Copy data activity must you configure?- AEnable logging
- BFault tolerance
- CEnable staging
- DDegree of copy parallelism
Información
- Descripción
- Test sobre DP-700, creado por Iván Mompó Arnáez el 14/04/2025.
- Autor
- Iván Mompó Arnáez
- Idioma
- English
- Visitas
- 1
- Valoración
- Aún sin valoraciones Valora este test