DP-600 Exam Question 1

You have a Fabric workspace named Workspacel that contains a lakehouse named Lakehousel. Lakehousel contains a table named Tablel. Table 1 contains the following data.

You need to perform the following actions:
* Load the data from Table! into a star schema.
* Create a product dimension table named DimProduct and a fact table named FactSales.
Which three columns should you include in DimProduct?
  • DP-600 Exam Question 2

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a Fabric tenant that contains a semantic model named Model1.
    You discover that the following query performs slowly against Model1.

    You need to reduce the execution time of the query.
    Solution: You replace line 4 by using the following code:

    Does this meet the goal?
  • DP-600 Exam Question 3

    You have a Fabric tenant that contains three users named User1, User2, and User3. The tenant contains a security group named Group 1. User1 and User3 are members of Group"1.
    The tenant contains the workspaces shown in the following table.

    The tenant contains the domains shown in the following table.

    User1 creates a new workspace named Workspace3.
    You assign Domain! as the default domain of Group1.
    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    DP-600 Exam Question 4

    You have Fabric tenant that contains four workspaces named Development, Test, QA, and Production. All the workspaces are in Premium Per User (PPU) license mode.
    You plan to use a release pipeline to support the development lifecycle from Development to Production.
    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    DP-600 Exam Question 5

    You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

    What can you identify about the pickupLongitude column?