Free Snowflake DSA-C02 Exam Dumps Questions & Answers

Which ones are the key actions in the data collection phase of Machine learning included?

• A.Label
• B.Probability
• C.Ingest and Aggregate
• D.Measure

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$FILE_ID
• B.METADATA$DELETE
• C.METADATA$ISUPDATE
• D.METADATA$ROW_ID
• E.METADATA$ACTION

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 Virtualization
• B.Data Profiling
• C.Data Collection
• D.Data Visualization

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 do not support repeatable read isolation.
• C.Streams can track changes in materialized views.
• D.Streams itself does not contain any table data.

Which of the Following is not type of Windows function in Snowflake?

• A.Window frame functions.
• B.Association functions.
• C.Rank-related functions.
• D.Aggregation window functions.