Snowflake SnowPro Core Certification - SnowPro-Core Exam Practice Test

A. SQL

B. Python

C. JavaScript

D. Swift

A. Maintaining Availability Zones

B. Parsing and optimizing queries

C. Management of metadata

D. Computing the data

E. Infrastructure security

A. MULTIPLE=FALSE

B. SINGLE=FALSE

C. SINGLE=TRUE

D. MULTIPLE=TRUE

A. Write SELECT queries to retrieve data from external tables.

B. Manage different databases and schemas.

C. Troubleshoot network connections to Snowflake.

D. Copy data into files.

A. 5 minutes

B. 60 minutes

C. 1 second

D. 60 seconds

A. REFERENCE_USAGE on databases

B. CREATE_SHARE on the account

C. SELECT on tables used by the secure view

D. SHARE on databases and schemas

A. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

B. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D. Account and user authentication is only available with the Snowflake Business Critical edition.

A. A task allows a user to execute a single SQL statement/command using a predefined schedule.

B. A task can be executed using a SELECT statement to run a predefined SQL command.

C. A task allows a user to execute a set of SQL commands on a predefined schedule.

D. A task can be called using a CALL statement to run a set of predefined SQL commands.

A. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

B. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

C. The ability to allow the result of a query to be accessed as if it were a table.

D. The filtering or disregarding of micro-partitions that are not needed to return a query.

A. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

B. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

C. Users who are trying to use the warehouse will receive an error message until the resizing is complete

D. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

A. SYSTEMADMIN_TAG

B. SYSTEMSALLONTLIST

C. SYSTEMAUTHORIZE

D. SYSTEM$GET_PRIVATELINK

A. Databases

B. Warehouses

C. Users

D. Roles

E. Accounts

A. REMOVE

B. DELETE

C. TRUNCATE

D. DROP

A. 60

B. 120

C. 91

D. 121