DP-600 Exam Question 6
You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2 and a user named User1.
You need to ensure that User1 can perform the following tasks:
- Create a new domain.
- Create two subdomains named subdomain1 and subdomain2.
- Assign Workspace1 to subdomain1.
- Assign Workspace2 to subdomain2.
The solution must follow the principle of least privilege.
Which role should you assign to User1?
You need to ensure that User1 can perform the following tasks:
- Create a new domain.
- Create two subdomains named subdomain1 and subdomain2.
- Assign Workspace1 to subdomain1.
- Assign Workspace2 to subdomain2.
The solution must follow the principle of least privilege.
Which role should you assign to User1?
DP-600 Exam Question 7
You have a Fabric workspace named Workspace1 and a warehouse named Warehouse1.
Workspace1 contains a user named User1. User1 is assigned the Viewer role for Workspace1.
You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the principle of least privilege.
Which role should you assign to User1?
Workspace1 contains a user named User1. User1 is assigned the Viewer role for Workspace1.
You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the principle of least privilege.
Which role should you assign to User1?
DP-600 Exam Question 8
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta Parquet table named FactSales. You use a Describe command to review the history of FactSales and notice that you have over 1000 versions of the table, and the retention policy is six months.
You need to reduce the size of the FactSales table and the number of files in the table. What should you configure on the table?
You need to reduce the size of the FactSales table and the number of files in the table. What should you configure on the table?
DP-600 Exam Question 9
You have a Fabric warehouse that contains a table named SalesOrderDetail, SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.
You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.
Which T-SQL statement should you run?
You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.
Which T-SQL statement should you run?
DP-600 Exam Question 10
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.
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.