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 (page: 9)

Page 8 of 36
PDF with 183 Questions

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales.
You need to create a diagram of the model. The diagram must contain only the Sales table and related tables.
What should you use from Microsoft Power BI Desktop?

  1. data categories
  2. Data view
  3. Model view
  4. DAX query view

Answer(s): C



You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode.
You suspect that some DAX queries load unnecessary columns into memory.
You need to identify the frequently used columns that are loaded into memory.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.

  1. Use the Analyze in Excel feature.
  2. Use the Vertipaq Analyzer tool.
  3. Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV).
  4. Query the DISCOVER_MEMORYGRANT dynamic management view (DMV).

Answer(s): B,C



HOTSPOT (Drag and Drop is not supported)
You have the source data model shown in the following exhibit.
The primary keys of the tables are indicated by a key symbol beside the columns involved in each key.
You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer.
What should you include in the solution? To answer, select the appropriate options in the answer area.
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 semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields.
You need to reduce the memory used by Model1 and the time it takes to refresh the model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

  1. Split OrderDateTime into separate date and time columns.
  2. Replace TotalQuantity with a calculated column.
  3. Convert Quantity into the Text data type.
  4. Replace TotalSalesAmount with a measure.

Answer(s): A,D






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

DP-600 Exam Discussions & Posts