Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 23 discussion

Actual exam question from Microsoft's DP-600

Question #: 23
Topic #: 1

HOTSPOT -
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.

Show Suggested Answer

Suggested Answer:

by Momoanwar at Feb. 17, 2024, 11:36 p.m.

Comments

Submit Cancel

estrelle2008

Highly Voted 1 year, 5 months ago

ALTER/SCHEMA This statement allows to alter (which includes truncating) tables within the specified schema. It ensures that the permission is restricted to schemaA and does not grant access to other schemas or objects.

upvoted 32 times

...

KipngenohVinnie

Highly Voted 11 months ago

GRANT ALTER ON SCHEMA::schemaA TO User1;

upvoted 6 times

...

Rakesh16

Most Recent 9 months ago

Alter, Schema_SchemaA

upvoted 1 times

...

py2356863

1 year, 2 months ago

ALTER/SCHEMA https://learn.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver16#permissions https://learn.microsoft.com/th-th/sql/t-sql/statements/alter-schema-transact-sql?view=fabric&preserve-view=true

upvoted 1 times

...

Valcon_doo_NoviSad

1 year, 2 months ago

truncating tables is not even supported in warehouse so this question is pointless, good job microsoft...

upvoted 5 times

waltXc

4 months, 4 weeks ago

TRUNCATE is now supported on Fabric's Data Warehouse: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Support-TRUNCATE-TABLE-in-Fabric-Warehouse/idi-p/4510865

upvoted 1 times

...

stilferx

1 year, 3 months ago

IMHO, ALTER -> SCHEMA. As well said below, 1) ALTER is the thing to have for truncating: https://learn.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver16&viewFallbackFrom=fabric 2) SCHEMA:schema_name to define a particular schema for tables

upvoted 1 times

...

VAzureD

1 year, 4 months ago

ALTER/SCHEMA https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql?view=sql-server-ver16 GRANT permission [ ,...n ] ON SCHEMA :: schema_name TO database_principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ]

upvoted 4 times

...

cresclux

1 year, 4 months ago

According to https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?view=sql-server-ver16, answer seems to ALTER and OBJECT.

upvoted 2 times

Priyanka007

1 year, 1 month ago

It would have worked if the question said one table.. But it says "user named User1 can truncate TABLE"S" in schemaA only" so I would go with option C. SCHEMA.

upvoted 1 times

...

benja84

1 year, 4 months ago

For schemas: https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql?view=sql-server-ver16

upvoted 2 times

...

AzureGeek79

1 year, 5 months ago

ALTER is DDL not DML so the right answer is EXECUTE SCHEMA.

upvoted 2 times

dev2dev

1 year, 2 months ago

TRUNCATE is DML

upvoted 2 times

dev2dev

1 year, 2 months ago

Ignore my prevous comment. TRUNCATE is DDL so ALTER is what we need

upvoted 1 times

...

thomaski123

1 year, 5 months ago

ALTER is required for Truncate https://learn.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver16&viewFallbackFrom=fabric

upvoted 4 times

...

Momoanwar

1 year, 5 months ago

Correct

upvoted 2 times

...