Which of the following is an example of a data validation check?

Creating a new feature from existing columns

Verifying that all values in a column fall within an expected range

Visualizing the data with a chart

A data scientist is building a topic modeling model on a corpus of news articles. The scientist wants to reduce the feature space and improve model performance. Which text preprocessing step is most appropriate?

Keep all words, including stop words, to preserve context.

Remove stop words and apply stemming.

Remove punctuation and convert to lowercase only.

Apply only tokenization without any filtering.

Which of the following is a core data cleaning technique used to prepare raw data for analysis?

Training a machine learning model

Writing a SQL query to join tables

Designing a data warehouse schema

A data scientist is working with a dataset that has a 'birth_date' column stored as a string in various formats (e.g., '1990-01-15', '01/15/1990', 'Jan 15, 1990'). The scientist needs to calculate age as of a fixed reference date. What is the most appropriate approach?

Parse each format into a datetime type, then compute age by subtracting the birth date from the reference date.

Use a single parser that assumes one format for all values.

Convert all strings to a common format like 'YYYYMMDD' and then subtract.

Extract the year from each string and subtract it from the reference year.

SnowflakeSnowPro Advanced — Data Scientist

Domain 3Objective 1

Prepare and Clean Data SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 2)

Part of the Data Preparation and Feature Engineering domain, which makes up ~26% of our current practice bank.

22questions here

5free pages

10concepts

Questions 6–10

6foundation · easy
Which of the following is an example of a data validation check?
Select an answer first
7foundation · easy
Which Snowflake function parses a string into a date using a specified format?
Select an answer first
8application · medium
A data scientist is building a topic modeling model on a corpus of news articles. The scientist wants to reduce the feature space and improve model performance. Which text preprocessing step is most appropriate?
Select an answer first
9foundation · easy
Which of the following is a core data cleaning technique used to prepare raw data for analysis?
Select an answer first
10expert · hard
A data scientist is working with a dataset that has a 'birth_date' column stored as a string in various formats (e.g., '1990-01-15', '01/15/1990', 'Jan 15, 1990'). The scientist needs to calculate age as of a fixed reference date. What is the most appropriate approach?
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.