SnowPro-Core Exam Questions

Total 161 Questions

Last Updated Exam : 16-Dec-2024

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT
statement.


A.

True


B.

False





A.
  

True



Reference: https://docs.snowflake.com/en/user-guide-data-unload.html

Which of the following statements would be used to export/unload data from Snowflake?


A.

COPY INTO @stage


B.

EXPORT TO @stage


C.

INSERT INTO @stage


D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);





A.
  

COPY INTO @stage



Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

What parameter controls if the Virtual warehouse starts immediately after the CREATE
WAREHOUSE statement?
Select one.


A.

INITTIALLY_SUSPENDED = TRUE/FALSE


B.

START_AFTCR_CREATE = TRUE/FALSE


C.

START_TTIME = 60 // (seconds from now)


D.

START.TIME = CURRENT.DATE()





A.
  

INITTIALLY_SUSPENDED = TRUE/FALSE



Which of the following are examples of operations that require a Virtual Warehouse to
complete, assuming no quires have been executed previously?
Choose 3 answers


A.

MIN(< < column value>>)


B.

COPY


C.

SUM(<< column value >>)


D.

UPDATE





B.
  

COPY



C.
  

SUM(<< column value >>)



D.
  

UPDATE



Select the different types of Internal Stages: (Choose three.)


A.

Named Stage


B.

User Stage


C.

Table Stage


D.

Schema Stage





A.
  

Named Stage



B.
  

User Stage



C.
  

Table Stage



Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-anduse.
html/#Snowflake-Internal-
Named-Stage

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:


A.

Scaling rhythmically


B.

Scaling max


C.

Scaling out


D.

Scaling Up





C.
  

Scaling out



What is the maximum compressed row size in Snowflake?


A.

8KB


B.

16MB


C.

50MB


D.

4000GB





B.
  

16MB



To run a Multi-Cluster Warehouse in auto-scale mode, a user would:


A.

Configure the Maximum Clusters setting to “Auto-Scale”


B.

Set the Warehouse type to “Auto”


C.

Set the Minimum Clusters and Maximum Clusters settings to the same value


D.

Set the Minimum Clusters and Maximum Clusters settings to the different values





D.
  

Set the Minimum Clusters and Maximum Clusters settings to the different values



Which of the following is true of Snowpipe via REST API?
Choose 2 answers


A.

you can only use it on internal Stages


B.

All COPY INTO options are available fluting pipe creation


C.

Snowflake automatically manages the compute required to execute the Pipe's copy into
commands


D.

Snowpipe keeps track of which files it has loaded





B.
  

All COPY INTO options are available fluting pipe creation



D.
  

Snowpipe keeps track of which files it has loaded



What is the minimum Snowflake edition that provides data sharing?


A.

Standard


B.

Premier


C.

Enterprise


D.

Business Critical Edition





A.
  

Standard



Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing


Page 3 out of 17 Pages
Previous