Snowflake SNOWPRO-CORE Exam Questions

Questions for the SNOWPRO-CORE were updated on : Sep 09 ,2024

Page 1 out of 96. Viewing questions 1-10 out of 960

Question 1

Which virtual warehouse privilege is required to view a load-monitoring chart?

  • A. MONTTOR
  • B. MODIFY
  • C. OPERATE
  • D. USAGE
Answer:

a

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

  • A. CREATE STAGE
  • C. COPY INTO
  • D. CREATE PIPE
Answer:

c

User Votes:
A
50%
C
50%
D
50%
Discussions
vote your answer:
A
C
D
0 / 1000

Question 3

What metadata does Snowflake store for rows in micro-partitions? (Choose two.)

  • A. Range of values
  • B. Distinct values
  • C. Index values
  • D. Sorted values
  • E. Null values
Answer:

ab

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  • A. The warehouse size does not change until all queries currently running in the warehouse have completed.
  • B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
  • C. The warehouse size does not change until the warehouse is suspended and restarted.
  • D. It does not return from the command until the warehouse has finished changing its size.
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

  • A. Ruby
  • B. Javascript
  • C. SQL
  • D. PERL
  • E. C#
Answer:

bc

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.

What will the query from the view return?

  • 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.
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

What is a characteristic of data micro-partitioning in Snowflake?

  • A. Micro-partitioning may introduce data skew
  • B. Micro-partitioning requires the definition of a partitioning schema
  • C. Micro-partitioning happens when the data is loaded
  • D. Micro-partitioning can be disabled within a Snowflake account
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

  • A. ACCESS_HYSTORY
  • B. LOAD_HYSTORY
  • C. QUERY_HISTORY
  • D. REST_EVENT_HISTORY
Answer:

a

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

Which command is used to unload files from an internal or external stage to a local file system?

  • A. COPY INTO
  • B. GET
  • C. PUT
  • D. TRANSFER
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

What is used to limit the credit usage of a virtual warehouse within a Snowflake account?

  • A. Load monitor
  • B. Resource monitor
  • C. Query Profile
  • D. Stream
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2