- (Topic 3)
How can a user improve the performance of a single large complex query in Snowflake?
Correct Answer:A
Scaling up the virtual warehouse in Snowflake involves increasing the compute resources available for a single warehouse, which can improve the performance of large and complex queries by providing more CPU and memory resources. References: Based on general cloud data warehousing knowledge as of 2021.
- (Topic 1)
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Correct Answer:DE
Semi-structured JSON, Parquet Snowflake supports unloading data in several semi-structured file formats, including Parquet and JSON. These formats allow for efficient storage and querying of semi-
structured data, which can be loaded directly into Snowflake tables without requiring a predefined schema12.
https://docs.snowflake.com/en/user-guide/data-unload- prepare.html#:~:text=Supported File Formats,- The following file&text=Delimited (CSV, TSV, etc.)
- (Topic 6)
Which statements reflect valid commands when using secondary roles? (Select TWO).
Correct Answer:CE
✑ Incorrect Commands:The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
✑ Snowflake Documentation (USE SECONDARY
ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary- roles.html
- (Topic 6)
The property mins_to_bypass_network_policy is set at which level?
Correct Answer:C
The propertymins_to_bypass_network_policyis set at the account level in Snowflake. This setting allows administrators to specify a time frame during which users can bypass network policies that have been set on their account. It is particularly useful in scenarios where temporary access needs to be granted from IPs not covered by the existing network policies. By adjusting this property at the account level, Snowflake administrators can manage and enforce network access controls efficiently across the entire account. References:
✑ Snowflake Documentation on Network Policies: Network Policies
- (Topic 2)
Where can a user find and review the failed logins of a specific user for the past 30 days?
Correct Answer:B
The LOGIN_HISTORY view in the ACCOUNT_USAGE schema provides information about login attempts, including both successful and failed logins. This view can be used to review the failed login attempts of a specific user for the past 30 days. References: [COF-C02] SnowPro Core Certification Exam Study Guide