Snowflake DSA-C02 SnowPro Advanced: Data Scientist Certification Exam Online Training
Snowflake DSA-C02 Online Training
The questions for DSA-C02 were last updated at Jan 05,2025.
- Exam Code: DSA-C02
- Exam Name: SnowPro Advanced: Data Scientist Certification Exam
- Certification Provider: Snowflake
- Latest update: Jan 05,2025
As Data Scientist looking out to use Reader account, Which ones are the correct considerations about Reader Accounts for Third-Party Access?
- A . Reader accounts (formerly known as “read-only accounts”) provide a quick, easy, and cost-effective way to share data without requiring the consumer to become a Snowflake customer.
- B . Each reader account belongs to the provider account that created it.
- C . Users in a reader account can query data that has been shared with the reader account, but cannot perform any of the DML tasks that are allowed in a full account, such as data loading, insert, update, and similar data manipulation operations.
- D . Data sharing is only possible between Snowflake accounts.
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;
Which object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data of Data Science Pipelines?
- A . Task
- B . Dynamic tables
- C . Stream
- D . Tags
- E . Delta
- F . OFFSET
Which are the following additional Metadata columns Stream contains that could be used for creating Efficient Data science Pipelines & helps in transforming only the New/Modified data only?
- A . METADATA$ACTION
- B . METADATA$FILE_ID
- C . METADATA$ISUPDATE
- D . METADATA$DELETE
- E . METADATA$ROW_ID