DP-600 무료 덤프문제 온라인 액세스

You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns.

You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000. Which query should you use?

• A.
• B.
• C.
• D.

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed.
You need all rows to appear in the visual. What should you do?

• A.Modify the Sort Column By property for all columns.
• B.Add a unique field to each row.
• C.Reference the columns in the Python code by index.
• D.Modify the Summarize By property for all columns.

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Modell supports XMLA connections.
Which setting should you modify?

• A.Enable Cache for Shortcuts
• B.License mode
• C.Users can edit data models in the Power B1 service
• D.Enforce strict access control for all data connection types

You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC You need to ensure that a user named User1 can truncate tables in schemaA only.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation:

GRANT ALTER ON SCHEMA::schemaA TO User1;
The ALTER permission allows a user to modify the schema of an object, and granting ALTER on a schema will allow the user to perform operations like TRUNCATE TABLE on any object within that schema. It is the correct permission to grant to User1 for truncating tables in schemaA.
References =
GRANT Schema Permissions
Permissions That Can Be Granted on a Schema

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1 and a lakehouse named Lakehouse1. Warehouse 1 contains a table named Table!. Lakehouse! contains a delta table named Table2.
You need to persist data from Table! to Table2. The solution must use a low-code interface. What should you do?

• A.Use a notebook to read the data from Table2 and insert the data into Tabid.
• B.Use a Dataflow Gen2 to read the data from Table! and insert the data into Table2.
• C.Use a notebook to read the data from Table! and insert the data into Table2.
• D.Use a stored procedure to read the data from Table2 and insert the data into Tabid.