Snowflake snowpro-core practice test

snowpro core

Last exam update: Oct 11 ,2024
Page 1 out of 95. Viewing questions 1-10 out of 960

Question 1

In the Snowflake access control model, which entity owns an object by default?

  • A. The user who created the object
  • B. The SYSADMIN role
  • C. Ownership depends on the type of object
  • D. The role used to create the object
Answer:

d

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

Question 2

What is the default access of a securable object until other access is granted?

  • A. No access
  • B. Read access
  • C. Write access
  • D. Full access
Answer:

a

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

Question 3

A user created a new worksheet within the Snowsight UI and wants to share this with teammates.

How can this worksheet be shared?

  • A. Create a zero-copy clone of the worksheet and grant permissions to teammates.
  • B. Create a private Data Exchange so that any teammate can use the worksheet.
  • C. Share the worksheet with teammates within Snowsight.
  • D. Create a database and grant all permissions to teammates.
Answer:

b

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

Question 4

Which command is used to generate a zero-copy snapshot of any table, schema, or database?

  • A. ALTER
  • B. CREATE ... CLONE
  • C. COPY INTO
  • D. CREATE REPLICATION GROUP
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 sequence (order) of object privileges should be used to grant a custom role read-only access on a table?

  • D. None
Answer:

c

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

Question 6

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  • A. Schema
  • B. View
  • C. Internal stage
  • D. Table
  • E. User
  • F. Role
Answer:

ad

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

Question 7

What is the default compression typo when unloading data from Snowflake?

  • A. Brotli
  • B. bzip2
  • C. Zstandard
  • D. gzip
Answer:

d

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

Question 8

Who can create network policies within Snowflake? (Choose two.)

  • A. SYSADMIN only
  • B. ORGADMIN only
  • C. SECURITYADMIN or higher roles
  • D. A role with the CREATE NETWORK POLICY privilege
  • E. A role with the CREATE SECURITY INTEGRATION privilege
Answer:

cd

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

Question 9

Which table function should be used to view details on a Directed Acyclic Graph (DAG) run that is presently scheduled or is executing?

  • A. TASK_HISTORY
  • B. TASK_DEPENDENTS
  • C. CURRENT_TASK_GRAPHS
  • D. COMPLETE_TASK_GRAPHS
Answer:

c

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 extract the content of PDF files stored in Snowflake stages?

  • A. FLATTEN function
  • B. Window function
  • C. HyperLogLog (HLL) function
  • D. Java User-Defined Function (UDF)
Answer:

d

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