Summer Special Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: vce65

A Data Scientist as data providers require to allow consumers to access all databases and...

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;

Snowflake DSA-C02 Summary

  • Vendor: Snowflake
  • Product: DSA-C02
  • Update on: Jul 20, 2025
  • Questions: 65
Price: $52.5  $149.99
Buy Now DSA-C02 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method