Free Snowflake DSA-C02 Exam Dumps Questions & Answers

Which of the following Functions do Support Windowing?

• A.  LISTAGG
• B.  EXTRACT
• C.  ENCRYPT
• D.  HASH_AGG

Which of the following is a useful tool for gaining insights into the relationship between features and predictions?

• A.  sklearn plots
• B.  numpy plots
• C.  Partial dependence plots(PDP)
• D.  FULL dependence plots (FDP)

Mark the Incorrect understanding of Data Scientist about Streams?

• A.  Streams on views support both local views and views shared using Snowflake Secure Data Sharing, including secure views.
• B.  Streams itself does not contain any table data.
• C.  Streams do not support repeatable read isolation.
• D.  Streams can track changes in materialized views.

Which of the following process best covers all of the following characteristics?
Collecting descriptive statistics like min, max, count and sum.
Collecting data types, length and recurring patterns.
Tagging data with keywords, descriptions or categories.
Performing data quality assessment, risk of performing joins on the data.
Discovering metadata and assessing its accuracy.
Identifying distributions, key candidates, foreign-key candidates,functional dependencies, embedded value dependencies, and performing inter-table analysis.

• A.  Data Collection
• B.  Data Visualization
• C.  Data Profiling
• D.  Data Virtualization

Which one is the incorrect option to share data in Snowflake?

• A.  a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.
• B.  a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.
• C.  a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.
• D.  a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.