Free SnowPro Core Certification Exam SnowPro-Core Exam Practice Test

- (Exam Topic 3) Snowflake's hierarchical key mode includes which keys? (Select TWO).

• Account master keys
• Database master keys
• File keys
• Secure view keys
• Schema master keys

- (Exam Topic 2) What is the minimum Snowflake edition required to use Dynamic Data Masking?

• Standard
• Enterprise
• Business Critical
• Virtual Private Snowflake (VPC)

- (Exam Topic 2) A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

• 1 second
• 60 seconds
• 5 minutes
• 60 minutes

- (Exam Topic 3) Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

• STRIP_NULL_VALUES
• SKIP_BYTE_ORDER_MARK
• REPLACE_INVALID_CHARACTERS
• VALIDATION_MODE

- (Exam Topic 2) What COPY INTO SQL command should be used to unload data into multiple files?

• SINGLE=TRUE
• MULTIPLE=TRUE
• MULTIPLE=FALSE
• SINGLE=FALSE

- (Exam Topic 2) Which of the following are best practices for loading data into Snowflake? (Choose three.)

• Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
• Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
• Enclose fields that contain delimiter characters in single or double quotes.
• Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
• When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
• Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

- (Exam Topic 2) What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

• 30 days
• 7 days
• 48 hours
• 24 hours

- (Exam Topic 3) Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

• Resource monitor
• Account_usage. query_history
• Information_schema.warehouse_load_history
• Information schema.warehouse metering history

- (Exam Topic 2) Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
• A user cannot specify a default warehouse when using the ODBC driver.
• The default virtual warehouse size can be changed at any time.

- (Exam Topic 3) What does Snowflake recommend regarding database object ownership? (Select TWO).

• Create objects with ACCOUNTADMIN and do not reassign ownership.
• Create objects with SYSADMIN.
• Create objects with SECURITYADMIN to ease granting of privileges later.
• Create objects with a custom role and grant this role to SYSADMIN.
• Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.