Snowflake Exam DSA-C02 Topic 4 Question 44 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 44
Topic #: 4

A Data Scientist as data providers require to allow consumers to access all databases and database objects in a share by granting a single privilege on shared databases. Which one is incorrect SnowSQL command used by her while doing this task?

Assuming:

A database named product_db exists with a schema named product_agg and a table named Item_agg.

The database, schema, and table will be shared with two accounts named xy12345 and yz23456.

1. USE ROLE accountadmin;

2. CREATE DIRECT SHARE product_s;

3. GRANT USAGE ON DATABASE product_db TO SHARE product_s;

4. GRANT USAGE ON SCHEMA product_db. product_agg TO SHARE product_s;

5. GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

6. SHOW GRANTS TO SHARE product_s;

7. ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

8. SHOW GRANTS OF SHARE product_s;

AGRANT USAGE ON DATABASE product_db TO SHARE product_s;

BCREATE DIRECT SHARE product_s;

CGRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

DALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

Show Suggested Answer

Suggested Answer: C

CREATE SHARE product_s is the correct Snowsql command to create Share object.

Rest are correct ones.

https://docs.snowflake.com/en/user-guide/data-sharing-provider#creating-a-share-using-sql

by Lawanda at Jul 05, 2025, 05:17 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sabina

2 days ago

I remember practicing a similar question, and I feel like the CREATE DIRECT SHARE command is pretty standard, so it should be fine.

upvoted 0 times

...

Rory

8 days ago

I think the command that grants SELECT on the table might be incorrect because it references a different database, right?

upvoted 0 times

...

Mayra

13 days ago

This looks straightforward enough. I think the key is to focus on the specific details provided in the question, like the database and schema names, and make sure the commands match up correctly.

upvoted 0 times

...

Whitley

19 days ago

I'm a bit confused on this one. There are a lot of steps involved, and I want to make sure I don't miss anything. I'll need to go through each command carefully and make sure I understand the purpose of each one.

upvoted 0 times

...

Joanna

24 days ago

Alright, I've got this. The incorrect command is option C, "GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;". The table is in the product_db database, not sales_db.

upvoted 0 times

...

Ahmed

29 days ago

Okay, let's see here. I think the key is to identify the incorrect SnowSQL command from the list provided. I'll need to double-check the documentation to make sure I'm using the right commands.

upvoted 0 times

...