DP-700 Exam Question 11

DRAG DROP
You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData.
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.
NOTE: Each correct selection is worth one point.

DP-700 Exam Question 12

You 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?
  • DP-700 Exam Question 13

    You need to ensure that WorkspaceA can be configured for source control. Which two actions should you perform?
    Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
  • DP-700 Exam Question 14

    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.

    DP-700 Exam Question 15

    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.