exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 193 discussion

Actual exam question from Microsoft's DP-600
Question #: 193
Topic #: 1
[All DP-600 Questions]

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1.

You share DW1 with User1 and assign User1 the default permissions for DW1.

What can User1 do?

  • A. Read data from the tables in DW1.
  • B. Build reports by using the default dataset.
  • C. Read the underlying Parquet files from OneLake.
  • D. Connect to DW1 via the TDS (Tabular Data Stream) endpoint.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
gwaff
5 days, 13 hours ago
Selected Answer: D
Correct answer is D, as according to Microsoft doc: - The shared recipient by default receives "Read" permission, which only allows the recipient to connect to the SQL analytics endpoint (see https://learn.microsoft.com/en-us/fabric/data-warehouse/share-warehouse-manage-permissions#fabric-security-roles) - In Fabric, TDS endpoint and SQL analytics endpoint are basically the same "Each Lakehouse has a built-in TDS endpoint called the SQL analytics endpoint" (see https://learn.microsoft.com/en-us/fabric/data-engineering/tutorial-lakehouse-introduction#architecture) "In Microsoft Fabric, a Lakehouse SQL analytics endpoint or Warehouse is accessible through a Tabular Data Stream, or TDS endpoint." (https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity)
upvoted 1 times
...
b979df8
1 week, 2 days ago
Selected Answer: A
A is the answer D is for dataverse B is additional permission not default C is not relevant
upvoted 1 times
...
82a46af
1 week, 5 days ago
Selected Answer: A
By default, sharing a warehouse in Microsoft Fabric grants the user Read permission, which allows them to: - Connect to the SQL analytics endpoint - Query tables and views using T-SQL - Access data through Spark or Power BI, depending on additional permissions TDS is used for tabular models, not SQL warehouses. DW1 uses SQL analytics endpoint, not TDS.
upvoted 1 times
...
maquint
1 week, 6 days ago
Selected Answer: A
A and B would be possible
upvoted 1 times
...
Duke_CT
1 week, 6 days ago
Selected Answer: D
D is the textbook answer for this situation.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...