New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake DSA-C02 Exam - Topic 4 Question 44 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 44
Topic #: 4
[All DSA-C02 Questions]

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;

Show Suggested Answer Hide 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, 04:17 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Natalie
2 months ago
Option A seems off too, but C definitely stands out as wrong.
upvoted 0 times
...
Cheryl
2 months ago
Wait, why is "sales_db" mentioned? Isn't it supposed to be "product_db"?
upvoted 0 times
...
Chara
2 months ago
Totally agree, C doesn't match the schema!
upvoted 0 times
...
Naomi
3 months ago
I thought all commands looked fine until I saw that!
upvoted 0 times
...
Sharee
3 months ago
I think option C is the incorrect command.
upvoted 0 times
...
Ettie
3 months ago
I have a feeling that the ALTER SHARE command is valid, but I can't recall if there are any specific restrictions on adding accounts.
upvoted 0 times
...
Deeann
3 months ago
I'm not entirely sure, but I think the GRANT USAGE on the database is correct since it’s necessary for sharing.
upvoted 0 times
...
Sabina
4 months 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
4 months 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
4 months 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
4 months 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
4 months 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
5 months 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
...
Xenia
5 months ago
Hmm, this looks like a tricky one. I'll need to carefully review the steps and make sure I understand the correct syntax for each command.
upvoted 0 times
...
Janessa
7 months ago
That makes sense. So, the correct answer is D. Thanks for clarifying!
upvoted 0 times
...
Yuriko
7 months ago
Because the ALTER SHARE command should not have the keyword 'ADD'.
upvoted 0 times
...
Yvonne
7 months ago
Haha, option D is definitely the odd one out. Who would share a database with accounts named xy12345 and yz23456? What are those, secret agent codes?
upvoted 0 times
Anabel
7 months ago
I know, right? It's definitely an interesting choice for sharing databases.
upvoted 0 times
...
Bernardo
7 months ago
Haha, you're right! Those account names do sound like secret agent codes.
upvoted 0 times
...
...
Janessa
7 months ago
Why do you think D is incorrect?
upvoted 0 times
...
Yuriko
7 months ago
I disagree, I believe the incorrect command is D.
upvoted 0 times
...
Janessa
7 months ago
I think the incorrect SnowSQL command is C.
upvoted 0 times
...
Ryan
8 months ago
Option B looks good to me. Creating a direct share is the right way to share the database and its objects.
upvoted 0 times
Veta
7 months ago
Then we can add the necessary accounts to the share using ALTER SHARE command.
upvoted 0 times
...
Rashad
7 months ago
After creating the direct share, we need to grant usage on the database to the share.
upvoted 0 times
...
Nathalie
7 months ago
Option B is correct. Creating a direct share is the first step.
upvoted 0 times
...
...
Elouise
8 months ago
I think option C is incorrect. The table name should be product_db.product_agg.Item_agg, not sales_db.product_agg.Item_agg.
upvoted 0 times
Phung
7 months ago
Thanks for pointing that out. The correct command should be GRANT SELECT ON TABLE product_db.product_agg.Item_agg TO SHARE product_s.
upvoted 0 times
...
My
8 months ago
Yes, you are right. It should be product_db.product_agg.Item_agg instead of sales_db.product_agg.Item_agg.
upvoted 0 times
...
Amie
8 months ago
Option C is incorrect. The table name should be product_db.product_agg.Item_agg, not sales_db.product_agg.Item_agg.
upvoted 0 times
...
...

Save Cancel