Microsoft DP-700 Exam Questions Instant Access

Question 1

You have an Azure subscription that contains a blob storage account named sa1. Sa1 contains two files named Filelxsv and File2.csv.

You have a Fabric tenant that contains the items shown in the following table.

You need to configure Pipeline1 to perform the following actions:

* At 2 PM each day, process Filel.csv and load the file into flhl.

* At 5 PM each day. process File2.csv and load the file into flhl.

The solution must minimize development effort. What should you use?

Aa job definition

Ba data pipeline schedule

Ca data pipeline trigger

Dan activator

Answer : B

Question 2

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

Answer : D

To compute the standard deviation of the temperature from the thermal sensor data, you would use the Aggregate transform operator in Eventstream1. The Aggregate operator allows you to apply functions like sum, average, count, and statistical functions like standard deviation across a group of rows or events. This operator is ideal for operations that require summarizing or computing statistics over a dataset, such as calculating the standard deviation.

Question 3

You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.

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.

Answer : B

Question 4

You 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

Answer : C

Question 5

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

Answer : D

When running a deployment pipeline in Fabric, if the items in Workspace1 are paired with the corresponding items in Workspace2 (based on the same name), the deployment pipeline will automatically overwrite the existing items in Workspace2 with the modified items from Workspace1. There's no need to delete, rename, or back up items manually unless you need to keep versions. By simply running deployPipeline1, the pipeline will handle overwriting the existing items in Workspace2 based on the pairing, ensuring the latest version of the items is deployed with minimal effort.

Question 6

You 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 Trips only

Answer : C

When reading data from shortcuts in Fabric (in this case, from a lakehouse like Lakehouse1), the cache for shortcuts helps by storing the data locally for quick access. The last accessed timestamp and the cache expiration rules determine whether data is fetched from the cache or from the source (Google Cloud Storage, in this case).

Products: The ProductFile.parquet was last accessed 12 hours ago. Since the cache has data available for up to 12 hours, it is likely that this data will be retrieved from the cache, as it hasn't been too long since it was last accessed.

Stores: The StoreFile.json was last accessed 4 hours ago, which is within the cache retention period. Therefore, this data will also be retrieved from the cache.

Trips: The TripsFile.csv was last accessed 48 hours ago. Given that it's outside the typical caching window (assuming the cache has a maximum retention period of around 24 hours), it would not be retrieved from the cache. Instead, it will likely require a fresh read from the source.

Question 7

What should you do to optimize the query experience for the business users?

AEnable V-Order.

BCreate and update statistics.

CRun the VACUUM command.

DIntroduce primary keys.

Answer : B

Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric DP-700 Exam Questions