Free SnowPro Core Certification Exam Practice Questions

A.  

To count the number of characters in a string

B.  

To split a string into an array of sub-strings

C.  

To split a string and flatten the results into rows

D.  

To split a string and flatten the results into columns

A.  

INTEGER

B.  

OBJECT

C.  

VARIANT

D.  

VARCHAR

E.  

LIST

A.  

CREATE TABLE < table_name > LIKE TABLE_A;

B.  

CREATE VIEW < view_name > AS SELECT * FROM TABLE_A;

C.  

CREATE TABLE < table_name > AS SELECT * FROM TABLE_A;

D.  

CREATE MATERIALIZED VIEW < view name > AS SELECT * FROM TABLE A;

A.  

Object owner

B.  

Schema owner

C.  

Database owner

D.  

SYSADMIN

A.  

Materialized views do not allow joins.

B.  

Clones of materialized views can be created directly by the user.

C.  

Multiple tables can be joined in the underlying query of a materialized view.

D.  

Aggregate functions can be used as window functions in materialized views.

A.  

A single data type, with one or more conditions, and one or more masking functions

B.  

A single data type, with only one condition, and only one masking function

C.  

Multiple data types, with only one condition, and one or more masking functions

D.  

Multiple data types, with one or more conditions, and one or more masking functions

A.  

File URL

B.  

Scoped URL

C.  

Relative URL

D.  

Pre-Signed URL

A.  

TO_CHAR

B.  

TO_VARIANT

C.  

TO_VARCHAR

D.  

STRIP NULL VALUE

A.  

The separation allows independent scaling of computing resources.

B.  

The separation ensures consistent data encryption across all virtual data warehouses.

C.  

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.  

Storage volume growth and compute usage growth can be tightly coupled.

E.  

Compute can be scaled up or down without the requirement to add more storage.

A.  

Warehouses that are multi-cluster can have nodes of different sizes.

B.  

Warehouses can be started and stopped at any time.

C.  

Warehouses can be resized at any time, even while running.

D.  

Warehouses are billed on a per-minute usage basis.

E.  

Warehouses can only be used for querying and cannot be used for data loading.

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

SHOW

B.  

MERGE

C.  

INSERT

D.  

DELETE

E.  

DESCRIBE

A.  

Queries without filters or aggregation

B.  

Queries with large scans and selective filters

C.  

Queries where the GROUP BY has high cardinality

D.  

Queries of tables that have search optimization service enabled

A.  

FOR

B.  

LOOP

C.  

REPEAT

D.  

WHILE

A.  

Tags

B.  

Comments

C.  

Internal tokenization

D.  

Row access policies

A.  

Add and remove members.

B.  

Delete data categories.

C.  

Approve and deny listing approval requests.

D.  

Transfer listing ownership.

E.  

Transfer ownership of a provider profile.

A.  

ACCESS_HISTORY

B.  

COPY_HISTORY

C.  

QUERY_HISTORY

D.  

ROW ACCESS POLICIES

A.  

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.  

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.  

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.  

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

A.  

GET_PRESIGNED_URL

B.  

GET_ABSOLUTE_PATH

C.  

BUILD_STAGE_FILE_URL

D.  

BUILD SCOPED FILE URL

A.  

COPY INTO

B.  

GET

C.  

LIST

D.  

PUT

E.  

REMOVE