Free SnowPro Core Certification Exam Practice Questions

A.  

Pre-signed URL

B.  

Account URL

C.  

Scoped URL

D.  

File URL

A.  

Account role

B.  

Custom role

C.  

Database role

D.  

Secondary role

A.  

Converts a VARIANT value into an object.

B.  

Extracts the raw value from the VARIANT column.

C.  

Casts the value from a VARIANT to a specified data type.

D.  

Generates a random sample from the VARIANT column.

A.  

src[ ' customer ' ][ ' EMAIL ' ]

B.  

src[ ' CUSTOMER ' ][ ' Email ' ]

C.  

SRC:Customer.Email

D.  

src:customer.email

E.  

SRC:customer.email

A.  

NULL

B.  

Undefined data

C.  

An empty siring

D.  

An invalid identifier error

A.  

When the query contains multiple filters and no data is returned.

B.  

When a virtual warehouse runs out of memory while executing the query.

C.  

When the number of queries exceeds the max_concurrency_level parameter setting.

D.  

When running queries that exceed the statement_timecut_in_seccnds parameter setting.

A.  

The table has only 1 micro-partition.

B.  

The table has 1 overlapping micro-partition.

C.  

The table has no overlapping micro-partitions.

D.  

The table has no micro-partitions.

A.  

Changing the monitoring frequency to the default value

B.  

Changing the monitoring start timestamp to the default value

C.  

Dropping and re-creating the monitor

D.  

Cloning the monitor and then editing the cloned monitor schedule

A.  

PUT

B.  

CREATE < object >

C.  

COPY INTO < table >

D.  

COPY INTO < location >

A.  

Use the COPY INTO command to individually load the needed files.

B.  

Use the COPY INTO command using the PATTERN parameter to define the needed files.

C.  

Use the REMOVE command to eliminate unwanted files, then use the COPY INTO command.

D.  

Use the GET command to download the needed files, then create a new stage and load the files onto the stage using the COPY INTO command.

A.  

Select LAST_QUERY_ID(-2)

B.  

Select LAST_QUERY_ID(2)

C.  

Select LAST_QUERY_ID(1)

D.  

Select LAST_QUERY_ID(2)

A.  

Create information_schema in a database

B.  

View usage information for all accounts in the organization.

C.  

Enable database cloning for an account in the organization.

D.  

Enable database replication for an account in the organization.

E.  

View micro-partition information for all accounts in the organization.

A.  

Use the ALTER TABLE ... RENAME command.

B.  

Use the CREATE TABLE AS SELECT, or CTAS, command.

C.  

Use the ALTER TABLE ... SWAP WITH command.

D.  

Use the CREATE TABLE ... CLONE command.

A.  

A stage with a directory table set to automatically refresh will be created.

B.  

A stage with a directory table that has metadata that must be manually refreshed will be created.

C.  

An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

D.  

The command will fail to run because the name of the directory table is not specified.

A.  

SHOW USERS

B.  

DESCRIBE USER

C.  

SHOW PARAMETERS

D.  

SHOW USER FUNCTIONS

E.  

SHOW CONNECTIONS

A.  

FLATTEN

B.  

OBJECT_KEYS

C.  

PARSE_JSON

D.  

ARRAYS_TO_OBJECT

A.  

The type of SQL statements executed

B.  

The number of tables or databases queried

C.  

The amount of data stored in the warehouse

D.  

The length of time the compute resources in each cluster run

A.  

Use sequence-gen era ted values

B.  

Programmatically reveal the identifiers.

C.  

Use secure views solely for query convenience.

D.  

Do not expose the sequence-generated column(s)

A.  

Object tagging

B.  

Data encryption

C.  

User-Defined Functions, or UDFs

D.  

Dynamic Data Masking

A.  

Authorisation

B.  

Access delegation

C.  

Data pruning

D.  

Data compression

E.  

Query parsing and optimization