Snowflake SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Question # 9 Topic 1 Discussion

Snowflake SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Question # 9 Topic 1 Discussion

DSA-C02 Exam Topic 1 Question 9 Discussion:
Question #: 9
Topic #: 1

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;


A.

GRANT USAGE ON DATABASE product_db TO SHARE product_s;


B.

CREATE DIRECT SHARE product_s;


C.

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


D.

ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;


Get Premium DSA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.