SnowPro Core

When loading data into Snowflake, the COPY command supports: Choose 2 answersA . JoinsB . FittersC . Data type conversionsD . Column reorderingE . AggregatesView AnswerAnswer: C,D

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale”B . Set the Warehouse type to “Auto”C . Set the Minimum Clusters and Maximum Clusters settings to the same valueD . Set the Minimum Clusters and Maximum Clusters settings to the...

True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.A . TrueB . FalseView AnswerAnswer: B

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Which formats are supported for unloading data from Snowflake? Choose 2 answersA . Delimited (CSV, TSV, etc.)B . AvroC . ISOND . ORCView AnswerAnswer: A,C

True or False: Snowflake charges a premium for storing semi-structured data.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

Which of the following are options when creating a Virtual Warehouse?A . Auto-suspendB . Auto-resumeC . Local SSD sizeD . User countView AnswerAnswer: A,B

Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?A . DatabaseB . TablesC . WarehousesD . WorksheetsView AnswerAnswer: A,C,D Explanation: Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html

Which are true of Snowflake roles?A . All grants to objects are given to roles, and never to usersB . In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operationC . The public role controls at...

Account-level storage usage can be monitored via:A . The snowflake wet Interface (UI) in the Databases section.B . The Snowflake web interface (UI) in the Account -> Billing a usage sectionC . The Information Schema -> ACCOUNT_USAGE_HISTORY ViewD . The Account usage Schema - > ACCOUNT_USAGE_METRICS ViewView AnswerAnswer: B Explanation:...