A data pipeline ingests sensor data that occasionally contains spikes due to equipment malfunctions. The data science team wants to detect and flag these anomalies in the pipeline, but they don't want to remove them because they may be used for predictive maintenance. They also want to monitor the pipeline for data quality issues. Which approach should they use?

Use a view that filters out anomalies and use that for modeling.

Use a SQL query to delete rows that are more than 3 standard deviations from the mean.

Use a Snowpark script to calculate rolling statistics and flag rows that deviate significantly, then store the flags in a separate column.

Use a task to run a query that replaces anomalous values with the median.

In a feature engineering pipeline, what is the purpose of one-hot encoding?

To reduce the dimensionality of the dataset

To scale numerical features to a standard range

To convert categorical variables into numerical format

To handle missing values in the dataset

SnowflakeSnowPro Advanced — Data Scientist

Domain 2Objective 1

Build Data Pipelines for Data Science Workloads SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 2)

Part of the Data Pipelining domain, which makes up ~15% of our current practice bank.

26questions here

6free pages

10concepts

Questions 6–10

6foundation · easy
In SQL, which clause is used to filter rows based on a condition during data transformation?
Select an answer first
7expert · hard
A data pipeline ingests sensor data that occasionally contains spikes due to equipment malfunctions. The data science team wants to detect and flag these anomalies in the pipeline, but they don't want to remove them because they may be used for predictive maintenance. They also want to monitor the pipeline for data quality issues. Which approach should they use?
Select an answer first
8foundation · easy
Which Snowflake feature allows you to train machine learning models using familiar Python libraries like scikit-learn directly on data in Snowflake?
Select an answer first
9foundation · easy
In a feature engineering pipeline, what is the purpose of one-hot encoding?
Select an answer first
10foundation · easy
Which Snowflake feature allows querying data directly from files in an external stage without first loading the data into a table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-SCIENTIST

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.

Build Data Pipelines for Data Science Workloads SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 2)

Questions 6–10

In SQL, which clause is used to filter rows based on a condition during data transformation?

Which Snowflake feature allows you to train machine learning models using familiar Python libraries like scikit-learn directly on data in Snowflake?

In a feature engineering pipeline, what is the purpose of one-hot encoding?

Which Snowflake feature allows querying data directly from files in an external stage without first loading the data into a table?

Keep studying — Data Pipelining