Pass the Microsoft Microsoft Certified: Fabric Data Engineer Associate DP-700 Questions and answers with CertsForce

You have a Fabric lakehouse that contains the resources shown in the following table.

You need to use a notebook to query for customers in the United States and load the filtered data into USCustomers. The solution must minimize the number of scripts used.

Which statement should you use?

You need to ensure that the authors can see only their respective sales data.

How should you complete the statement? 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.

You need to resolve the sales data issue. The solution must minimize the amount of data transferred.

What should you do?

HOTSPOT

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.

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

You have a Fabric workspace that contains a notebook named Notebook1 and an Azure Data Factory pipeline named Pipeline1. Pipeline1 runs Notebook1 by using a notebook activity and passes simple parameter types.

Notebook1 contains the following cells:

Cell 3: Contains %%configure code that sets Apache Spark session properties

Cell 5: Contains a designated parameters cell

During an execution of Pipeline1, the pipeline fails before any business logic runs.

You need to ensure that Pipeline1 runs successfully.

What should you do?

You have a Fabric workspace.

You plan to deploy two Apache Spark environments that will each contain one of the following notebooks:

• Notebook 1: A data ingestion notebook that will run as a scheduled Spark job

• Notebook2; An ad hoc notebook for interactive data analysis that will be used by a team of analysts and data scientists

You need to configure the Spark environments to meet the following requirements:

• For the environment that contains Notebook 1, minimize compute costs.

• For the environment that contains Notebook2, support multiple concurrent users.

What should you use for each environment? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

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.