ExamGecko
Login
Home / Microsoft / DP-700 / List of questions
Ask Question

Microsoft DP-700 Practice Test - Questions Answers, Page 7

Add to Whishlist

List of questions

Question 61

Report Export Collapse

Note: 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.

Microsoft DP-700 image Question 61 63879391759716307161010

Reference contains reference data in the following format.

Microsoft DP-700 image Question 61 63879391759716307161010

Both tables contain millions of rows.

You have the following KQL queryset.

Microsoft DP-700 image Question 61 63879391759716307161010

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 62

Report Export Collapse

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.

Microsoft DP-700 image Question 62 63879391759731931596891

You need to build two KQL queries. The solution must meet the following requirements:

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.


Become a Premium Member for full access
  Unlock Premium Member

Question 63

Report Export Collapse

HOTSPOT

You are processing streaming data from an external data provider.

You have the following code segment.

Microsoft DP-700 image Question 63 63879391759747556232772

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 64

Report Export Collapse

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1.

You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1MB each.

You need to minimize how long it takes to query Table1.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 65

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 66

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 67

Report Export Collapse

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

You discover that Pipeline1 keeps failing.

You need to identify which SQL query was executed when the pipeline failed.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 68

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 69

Report Export Collapse

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.


Become a Premium Member for full access
  Unlock Premium Member

Question 70

Report Export Collapse

You need to schedule the population of the medallion layers to meet the technical requirements.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member
Total 100 questions
Go to page: of 10
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You 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?
You 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?
You 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?
You 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?
HOTSPOT 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.
You 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.
You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.
Exhibit. You 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?
HOTSPOT 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 [email protected]. 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.
You 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.