CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-600

Free DP-600 Exam Braindumps

You have a Fabric tenant that contains a semantic model.
You need to prevent report creators from populating visuals by using implicit measures.
What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.

  1. Microsoft Power BI Desktop
  2. Tabular Editor
  3. Microsoft SQL Server Management Studio (SSMS)
  4. DAX Studio

Answer(s): A,B



HOTSPOT (Drag and Drop is not supported)
You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is 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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a Fabric tenant that contains a lakehouse named Lakehouse’. Lakehouse1 contains a table named Tablet.
You are creating a new data pipeline.
You plan to copy external data to Table’. 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?

  1. From the Source tab, add additional columns.
  2. From the Destination tab, set Table action to Overwrite.
  3. From the Settings tab, select Enable staging.
  4. From the Source tab, select Enable partition discovery.
  5. From the Source tab, select Recursively.

Answer(s): B



You have a Fabric tenant that contains a lakehouse.
You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3) storage bucket.
You need to recommend which file format to use and where to create a shortcut.
Which two actions should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

  1. Create a shortcut in the Files section.
  2. Use the Parquet format
  3. Use the CSV format.
  4. Create a shortcut in the Tables section.
  5. Use the delta format.

Answer(s): B,D






Post your Comments and Discuss Microsoft DP-600 exam with other Community members:

DP-600 Exam Discussions & Posts