A data engineer is preparing a dataset of network flow logs for training an anomaly detection model. The logs contain columns for timestamp, source IP, destination IP, port, and bytes transferred. Some rows have missing values in the 'bytes' column, and the 'timestamp' column is stored as a string. What is the most important step to take before training the model?

Load the data into a separate table and use the COPY INTO command to automatically fix data types.

Use the REPLACE function to substitute the missing values with the average bytes transferred.

Create a view that only includes rows where the 'bytes' column is not null.

Convert the timestamp column to a TIMESTAMP data type and handle the missing values in the 'bytes' column.

A security analyst wants to proactively identify users who are at high risk of having their accounts compromised. They have historical data on user behavior, including login frequency, access times, and data exfiltration incidents. Which Snowflake capability should they use to predict which users are most likely to be compromised in the next 30 days?

Use Cortex to generate a natural language summary of user behavior.

Use SNOWFLAKE.ML.ANOMALY_DETECTION to find users whose behavior is currently anomalous.

Use SNOWFLAKE.ML.CLASSIFICATION to build a model that predicts a 'compromised' or 'not compromised' label for each user.

Use SNOWFLAKE.ML.FORECAST to predict the number of compromise incidents for the entire organization.

What is the primary purpose of using predictive analytics in security threat modeling?

To classify past security events into categories

To forecast potential security threats or risky user behaviors

To detect anomalies in real-time data

To encrypt sensitive security data

Snowflake SnowPro Advanced:Security Engineer

Domain 5Objective 1

Leverage Snowflake AI/ML Capabilities to Enhance Security Posture SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 2)

Part of the AI/ML Security domain, which makes up ~9% of our current practice bank.

27questions here

6free pages

8concepts

Questions 6–10

6foundation · easy
Which Snowflake ML function is used to categorize security events into predefined classes, such as 'malicious' or 'benign'?
Select an answer first
7application · medium
A data engineer is preparing a dataset of network flow logs for training an anomaly detection model. The logs contain columns for timestamp, source IP, destination IP, port, and bytes transferred. Some rows have missing values in the 'bytes' column, and the 'timestamp' column is stored as a string. What is the most important step to take before training the model?
Select an answer first
8application · medium
A security analyst wants to proactively identify users who are at high risk of having their accounts compromised. They have historical data on user behavior, including login frequency, access times, and data exfiltration incidents. Which Snowflake capability should they use to predict which users are most likely to be compromised in the next 30 days?
Select an answer first
9application · medium
A security team wants to integrate Snowflake with an external threat intelligence platform. The platform provides a REST API that can be called to enrich IP addresses with threat data. The team wants to call this API from within a Snowflake SQL query to enrich their login logs. Which Snowflake feature should they use?
Select an answer first
10foundation · easy
What is the primary purpose of using predictive analytics in security threat modeling?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-SECURITY-ENGINEER

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-SECURITY-ENGINEER” is a trademark of its owner, used for identification only.

Leverage Snowflake AI/ML Capabilities to Enhance Security Posture SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 2)

Questions 6–10

Which Snowflake ML function is used to categorize security events into predefined classes, such as 'malicious' or 'benign'?

What is the primary purpose of using predictive analytics in security threat modeling?

Keep studying — AI/ML Security