Snowflake snowpro-core practice test

snowpro core

Last exam update: Jun 18 ,2024
Page 1 out of 96. Viewing questions 1-10 out of 960

Question 1

Which file format will keep floating-point numbers from being truncated when data is unloaded?

  • A. CSV
  • B. JSON
  • C. ORC
  • D. Parquet
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

D. Parquet

2 weeks, 4 days ago

D. Parquet

2 weeks, 4 days ago

D. Parquet


Question 2

What is a characteristic of the maintenance of a materialized view?

  • A. Materialized views cannot be refreshed automatically.
  • B. An additional set of scripts is needed to refresh data in materialized views.
  • C. A materialized view is automatically refreshed by a Snowflake managed warehouse.
  • D. A materialized view can be set up with the auto-refresh feature using the SQL SET command.
Mark Question:
Answer:

c

User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

C. A materialized view is automatically refreshed by a Snowflake managed warehouse.

2 weeks, 4 days ago

C. A materialized view is automatically refreshed by a Snowflake managed warehouse.

2 weeks, 4 days ago

C. A materialized view is automatically refreshed by a Snowflake managed warehouse.


Question 3

What command is used to export or unload data from Snowflake?

  • A. PUT @mystage
  • B. GET @mystage
  • C. Copy INTO @mystage
  • D. INSERT @mystage
Mark Question:
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

B. GET @mystage

2 weeks, 4 days ago

B. GET @mystage

2 weeks, 4 days ago

B. GET @mystage


Question 4

Which command should be used to unload all the rows from a table into one or more files in a named stage?

  • A. COPY INTO
  • B. GET
  • C. INSERT INTO
  • D. PUT
Mark Question:
Answer:

a

User Votes:
A
50%
B 1 votes
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

A. COPY INTO

2 weeks, 4 days ago

A. COPY INTO


Question 5

In which layer of its architecture does Snowflake store its metadata statistics?

  • A. Storage Layer
  • B. Compute Layer
  • C. Database Layer
  • D. Cloud Services Layer
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D
50%

Reference:
https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

D. Cloud Services Layer

2 weeks, 4 days ago

D. Cloud Services Layer

2 weeks, 4 days ago

D. Cloud Services Layer


Question 6

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

  • A. ACCOUNTADMIN
  • B. SECURITYADMIN
  • C. SYSADMIN
  • D. USERADMIN
Mark Question:
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

A. ACCOUNTADMIN

2 months, 1 week ago

B. SECURITYADMIN

2 weeks, 4 days ago

A. ACCOUNTADMIN

2 weeks, 4 days ago

B. SECURITYADMIN


Question 7

How does Snowflake Fail-safe protect data in a permanent table?

  • A. Fail-safe makes data available up to 1 day, recoverable by user operations.
  • B. Fail-safe makes data available for 7 days, recoverable by user operations.
  • C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  • D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Mark Question:
Answer:

c

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

2 weeks, 4 days ago

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

2 weeks, 4 days ago

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.


Question 8

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

  • A. Load the data into a CSV file.
  • B. Load the data into a relational table.
  • C. Use the VALIDATION_MODE = SQL statement.
  • D. Use the VALIDATION_MODE = RETURN_ROWS statement.
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

D. Use the VALIDATION_MODE = RETURN_ROWS statement.

2 weeks, 4 days ago

D. Use the VALIDATION_MODE = RETURN_ROWS statement.

2 weeks, 4 days ago

D. Use the VALIDATION_MODE = RETURN_ROWS statement.


Question 9

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

  • A. Configure the warehouse to a size larger than generally required
  • B. Set the minimum and maximum clusters to autoscale
  • C. Use the standard warehouse scaling policy
  • D. Use the economy warehouse scaling policy
Mark Question:
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

B. Set the minimum and maximum clusters to autoscale

2 weeks, 4 days ago

B. Set the minimum and maximum clusters to autoscale

2 weeks, 4 days ago

B. Set the minimum and maximum clusters to autoscale


Question 10

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

  • A. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
  • B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
  • C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
  • D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Mark Question:
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
2 months, 1 week ago

C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

2 months, 1 week ago

B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

2 weeks, 4 days ago

B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

2 weeks, 4 days ago

B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

To page 2