Free SnowPro Associate: Platform Certification Exam Practice Questions

A.  

Transfer ownership of the object to the role.

B.  

Assign the PUBLIC role.

C.  

Grant privileges to the role.

D.  

Clone the object and grant the role privileges to the cloned object.

A.  

SELECT * FROM employees LIMIT 10;

B.  

SELECT LIMIT 10 * FROM employees;

C.  

LIMIT 10 SELECT * FROM employees;

D.  

SELECT * FROM employees WHERE LIMIT 10;

A.  

Changing the size of the warehouse (e.g., from Small to Medium or vice versa).

B.  

Moving data between different storage locations.

C.  

Changing the region of the warehouse.

D.  

Adjusting the number of clusters in a multi-cluster warehouse.

A.  

ABORT_STATEMENT

B.  

SKIP_FILE

C.  

VALIDATE

D.  

CONTINUE

A.  

Schemas

B.  

Roles

C.  

Tables

D.  

Stages

A.  

Compute Layer

B.  

Data Storage Layer

C.  

Cloud Services Layer

D.  

Query Processing Layer

A.  

The cell has errors

B.  

The cell is currently running

C.  

The cell has completed execution successfully

D.  

The cell is paused

A.  

They always require payment for access.

B.  

They are limited to static data snapshots.

C.  

They can be free or paid, depending on the provider's terms.

D.  

They are only accessible to Snowflake administrators.

A.  

Multi-cluster Warehouses can automatically scale horizontally by adding more clusters.

B.  

Standard Warehouses can only be used for data loading.

C.  

Multi-cluster warehouses cannot be auto suspended.

D.  

Standard Warehouses provide better performance for complex queries.

A.  

To automatically manage timestamp data types

B.  

To ensure that users' data can be recovered at any time

C.  

To facilitate the loading of historical data into Snowflake

D.  

To allow users to access historical data