Free Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1A user belongs to two Fabric workspace groups: one assigned Viewer and one assigned Contributor. Which workspace role determines the user's effective capabilities?

   1. A. Viewer, because the more restrictive group takes precedence.
   2. B. Contributor, because the highest assigned permission level applies.
   3. C. Member, because permissions from two groups advance one role.
   4. D. Admin, because membership in multiple groups grants administration.

   Answer: B

   Explanation: Microsoft states: "If someone is in several user groups, they get the highest level of permission that's provided by the roles that they're assigned." Contributor is the higher of the two assigned roles.

   Reference: Roles in workspaces in Microsoft Fabric — Workspace role assignment, paragraph before Microsoft Fabric workspace roles

2. 2An analytics team requires a relational enterprise data warehouse, T-SQL authoring, and full SQL transaction support. Which Fabric store aligns with these requirements?

   1. A. Lakehouse
   2. B. Eventhouse
   3. C. Data Warehouse
   4. D. Cosmos DB in Fabric

   Answer: C

   Explanation: The store guide assigns "Enterprise data warehouse, SQL-based BI, OLAP, full SQL transaction support" to Data Warehouse. The other stores target different data and workload patterns.

   Reference: Choose a data store in Microsoft Fabric — Ideal use case — Data Warehouse

3. 3Power Query reads data from a local Excel workbook. The model should keep a periodically refreshed snapshot for report queries rather than query the workbook per visual. Which table storage mode fits?

   1. A. DirectQuery
   2. B. Direct Lake on SQL
   3. C. Live connect
   4. D. Import

   Answer: D

   Explanation: Microsoft describes Import as: "A snapshot of the data is stored in native storage for the quick loading of visuals in reports." Refresh updates that snapshot.

   Reference: Manage storage mode in Power BI Desktop — Table storage modes — Import

4. 4A Fabric workspace user has Contributor permissions and needs to configure a gateway connection. Why might the workspace role alone be insufficient?

   1. A. Gateway permissions are managed independently of workspace permissions.
   2. B. Contributor permissions apply only to the workspace's Power BI reports.
   3. C. Gateway access is granted only through a semantic model's Build permission.
   4. D. Gateway permissions are inherited solely from item sensitivity labels.

   Answer: A

   Explanation: The workspace-role footnote states: "Those permissions are managed elsewhere, independent of workspace roles and permissions." Separate gateway permissions must therefore be checked.

   Reference: Roles in workspaces in Microsoft Fabric — Microsoft Fabric workspace roles, footnote 4

5. 5Data scientists need to prepare structured and unstructured data with PySpark notebooks for machine learning. Which Fabric data store is designed for this workload?

   1. A. Lakehouse
   2. B. SQL database in Fabric
   3. C. Data Warehouse
   4. D. Eventhouse

   Answer: A

   Explanation: The guide associates Lakehouse with "Big data and machine learning, unstructured, semi-structured, or structured data, data engineering". Its Spark tooling matches the required development workflow.

   Reference: Choose a data store in Microsoft Fabric — Ideal use case — Lakehouse; Personas and skillsets — Lakehouse

6. 6For a supported SQL source, a table must retrieve data from the source as report visuals load instead of storing a snapshot in the semantic model. Which storage mode implements this?

   1. A. DirectQuery
   2. B. Import
   3. C. Dual used only as cache
   4. D. A calculated table

   Answer: A

   Explanation: Microsoft states for DirectQuery: "Data is queried from the data source when visuals load and isn't stored in the semantic model." This is source-query behavior rather than snapshot refresh.

   Reference: Manage storage mode in Power BI Desktop — Table storage modes — DirectQuery

7. 7A Viewer needs permission to reshare one Fabric item without receiving a broader workspace role. Which permission supports this?

   1. A. Build permission on the item
   2. B. ReadData permission on the item
   3. C. Reshare permission on the item
   4. D. ReadAll permission on the item

   Answer: C

   Explanation: The roles documentation states: "Contributors and Viewers can also share items in a workspace, if they have Reshare permissions." The workspace role does not have to be increased.

   Reference: Roles in workspaces in Microsoft Fabric — Microsoft Fabric workspace roles, footnote 1

8. 8An application generates continuous high-granularity event logs that require interactive analysis using KQL. Which Fabric data store is the intended fit?

   1. A. SQL database in Fabric
   2. B. Eventhouse
   3. C. Data Warehouse
   4. D. Cosmos DB in Fabric

   Answer: B

   Explanation: Microsoft states: "For streaming event data and high-granularity interactive analytics, use an eventhouse." Its KQL-oriented analytics matches the event workload.

   Reference: Choose a data store in Microsoft Fabric — Data store decision guide — Eventhouse

9. 9A composite model has Import and DirectQuery fact tables from the same SQL source. Shared dimensions should support cached queries while avoiding limited relationships to the DirectQuery facts where possible. Which dimension storage mode fits?

   1. A. Import only
   2. B. Dual
   3. C. Direct Lake on SQL
   4. D. Hybrid

   Answer: B

   Explanation: Microsoft explains: "Dual tables can act as either DirectQuery or Import tables". This lets shared dimensions participate in the applicable source group and reduce limited relationships in the stated same-source design.

   Reference: Manage storage mode in Power BI Desktop — Propagation of the Dual setting

10. 10What does a People with existing access link do when shared for a Fabric item?

    1. A. It grants Read permission to every internal recipient.
    2. B. It grants Share permission to the named recipients.
    3. C. It gives guests access without an Entra guest account.
    4. D. It points to the item without granting access.

    Answer: D

    Explanation: Microsoft states that this link "doesn't grant any access to the item." Recipients must already have the necessary permissions.

    Reference: Share items in Microsoft Fabric — Share an item via link — People with existing access