Free SnowPro Core Certification Exam Practice Questions

A.  

Analyze query performance.

B.  

Write queries and execute them.

C.  

Provide an overview of the listings in the Snowflake Marketplace.

D.  

Connect to Snowflake partners to explore extended functionality.

A.  

All columns in a micro-partition

B.  

Any columns accessed during the query

C.  

The columns in the result set of the query

D.  

All rows accessed during the query

A.  

Modify the columns in the underlying table

B.  

Use the ALTER VIEW command to update the view

C.  

Recreate the view with the required changes

D.  

Materialize the view to perform the changes

A.  

A reader account can consume data from the provider account that created it and combine it with its own data.

B.  

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.  

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.  

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

A.  

Java

B.  

Javascript

C.  

Scala

D.  

Python

E.  

SQL

A.  

The data from the permanent table.

B.  

The data from the temporary table.

C.  

An error stating that the view could not be compiled.

D.  

An error stating that the referenced object could not be uniquely identified.

A.  

GO driver

B.  

Node.js driver

C.  

ODBC driver

D.  

Python connector

E.  

Spark connector

A.  

A logical grouping of objects that belongs to a single database

B.  

A logical grouping of objects that belongs to multiple databases

C.  

A named Snowflake object that includes all the information required to share a database

D.  

A uniquely identified Snowflake account within a business entity

A.  

Authy

B.  

Duo Security

C.  

One Login

D.  

RSA SecurlD Access

A.  

COPY INTO

B.  

CREATE PIPE

C.  

INSERT INTO

D.  

TABLE STREAM

A.  

A User-Defined Table Function (UDTF)

B.  

A Scalar User Function (UDF)

C.  

A stored procedure

D.  

A task

A.  

CHECK_JSON

B.  

TO_JSON

C.  

FLATTEN

D.  

PARSE_JSON

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

Temporary table

B.  

External table

C.  

Secure view

D.  

Materialized view

A.  

Use the SECURITYADMIN role.

B.  

Use the SYSADMIN role.

C.  

Use the USERADMIN role.

D.  

Contact Snowflake Support.

A.  

Disjuncts (OR) in join predicates

B.  

LIKE/ILIKE/RLIKE join predicates

C.  

Join predicates on VARIANT columns

D.  

Conjunctions (AND) of multiple equality predicates

A.  

Reader account users cannot add new data to the account.

B.  

Reader account users can share data to other reader accounts.

C.  

A single reader account can consume data from multiple provider accounts.

D.  

Data consumers are responsible for reader account setup and data usage costs.

E.  

Reader accounts enable data consumers to access and query data shared by the provider.

A.  

It uses a local data repository for all compute nodes in the platform.

B.  

It is a blend of shared-disk and shared-everything database architectures.

C.  

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

D.  

It reorganizes loaded data into internal optimized, compressed, and row-based format.

A.  

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.  

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.  

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

A.  

60

B.  

91

C.  

120

D.  

121