QUESTION: 40

You have source data in a folder on a local computer.
You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:
Support the use of dataflows to load and append data to the data store.
Ensure that Delta tables are V-Order optimized and compacted automatically.
Which type of data store should you use?

a lakehouse
an Azure SQL database
a warehouse
a KQL database

Answer(s): A

Reveal Solution Next Question

QUESTION: 41

HOTSPOT (Drag and Drop is not supported)
You have a Fabric tenant that contains a lakehouse.
You are using a Fabric notebook to save a large DataFrame by using the following code. df.write.partitionBy(“year”, “month”, “day”).mode(“overwrite”).parquet(“Files/SalesOrder”)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 42

You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit.
You need to transform the data columns into attribute-value pairs, where columns become rows.
You select the VendorID column.
Which transformation should you select from the context menu of the VendorID column?

Group by
Unpivot columns
Unpivot other columns
Split column
Remove other columns

Answer(s): C

Reveal Solution Next Question

QUESTION: 43

You have a Fabric tenant that contains a data pipeline.
You need to ensure that the pipeline runs every four hours on Mondays and Fridays.
To what should you set Repeat for the schedule?

Daily
By the minute
Weekly
Hourly

Answer(s): C

Reveal Solution Next Question

Free DP-600 Exam Braindumps (page: 12)

QUESTION: 40

QUESTION: 41

Explanation:

QUESTION: 42

QUESTION: 43

DP-600 Exam Discussions & Posts