DP-600 Practice Test

DP-600 Practice Test practice questions, page 9 of 9, with answer review and explanations.

Question 41

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.

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?

  1. Group by
  2. Unpivot columns
  3. Unpivot other columns
  4. Split column
  5. Remove other columns

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?

  1. Daily
  2. By the minute
  3. Weekly
  4. Hourly

Question 44

You have a Fabric tenant that contains a warehouse. Several times a day, the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring?

  1. the Capacity settings
  2. the Monitoring hub
  3. dynamic management views (DMVs)
  4. the Microsoft Fabric Capacity Metrics app