SnowflakeSnowPro Advanced — Data Scientist
Domain 2Objective 2
Ingest and Prepare Data in Snowflake SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 2)
Part of the Data Pipelining domain, which makes up ~15% of our current practice bank.
23questions here
5free pages
9concepts
Questions 6–10
- 6
Which SQL function is commonly used in Snowflake to replace NULL values with a specified default value?
Select an answer first - 7
Which SQL technique is used to remove duplicate rows from a dataset in Snowflake?
Select an answer first - 8
Which function is used in Snowflake to extract a value from a VARIANT column containing JSON data?
Select an answer first - 9
A data engineer is troubleshooting a Snowpipe that is not loading files from an external stage. The pipe was created successfully, and the stage has files. The engineer has verified that the file format is correct. Which of the following is a likely cause of the issue?
Select an answer first - 10
A data engineer is setting up a stage to load Parquet files into Snowflake. The files have a nested structure with arrays and objects. The engineer wants to ensure that the file format is correctly configured to handle the Parquet data. Which file format option is essential for loading Parquet files?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-SCIENTIST” is a trademark of its owner, used for identification only.