DP-600 Exam Question 61

You are creating a report and a semantic model in Microsoft Power Bl Desktop.
The Value measure has the expression shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

DP-600 Exam Question 62

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1.
You are creating a new data pipeline.
You plan to copy external data to Table1. The schema of the external data changes regularly.
You need the copy operation to meet the following requirements:
* Replace Table1 with the schema of the external data.
* Replace all the data in Table1 with the rows in the external data.
You add a Copy data activity to the pipeline. What should you do for the Copy data activity?
  • DP-600 Exam Question 63

    You have a Fabric tenant that contains a lakehouse named Lakehouse1
    Readings from 100 loT devices are appended to a Delta table in Lakehouse1. Each set of readings is approximately 25 KB. Approximately 10 GB of data is received daily.
    All the table and SparkSession settings are set to the default.
    You discover that queries are slow to execute. In addition, the lakehouse storage contains data and log files that are no longer used.
    You need to remove the files that are no longer used and combine small files into larger files with a target size of 1 GB per file.
    What should you do? To answer, drag the appropriate actions to the correct requirements. Each action 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-600 Exam Question 64

    You have a Microsoft Power Bl semantic model.
    You plan to implement calculation groups.
    You need to create a calculation item that will change the context from the selected date to month-to-date (MTD).
    How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-600 Exam Question 65

    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?