DP-700 Free Practice Test

HOTSPOT - (Topic 3)
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.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
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?

1. A. Enable high concurrency for notebooks.
2. B. Enable dynamic allocation for the Spark pool.
3. C. Change the runtime version.
4. D. Increase the number of executors.

Correct Answer: A
To ensure that Notebook2 can attach to the same Apache Spark session as Notebook1, you need to enable high concurrency for notebooks. High concurrency allows multiple notebooks to share a Spark session, enabling them to run within the same Spark context and thus share resources like cached data, session state, and compute capabilities. This is particularly useful when you need notebooks to run in sequence or together while leveraging shared resources.

- (Topic 3)
You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.

What will occur the next time Pipelinel tuns?

1. A. Both activities will run simultaneously.
2. B. Both activities will be skipped.
3. C. Execute procedurel will run and Copy_kdi will be skipped.
4. D. Copy.kdi will run and Execute procedurel will be skipped.
5. E. Execute procedure1 will run first, and then Copy_kdi will run.
6. F. Copy.kdi will run first, and then Execute procedurel will run.

Correct Answer: A

- (Topic 2)
What should you do to optimize the query experience for the business users?

1. A. Enable V-Order.
2. B. Create and update statistics.
3. C. Run the VACUUM command.
4. D. Introduce primary keys.

Correct Answer: B