Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 51:

  The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

  A. Local disk caching

  B. Authentication and access control

  C. Metadata management

  D. Query processing

  E. Database storage

  Correct Answer: BC

• Question 52:

  Which command can be used to load data files into a Snowflake stage?

  A. JOIN

  B. COPY INTO

  C. PUT

  D. GET

  Correct Answer: C

• Question 53:

  Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

  A. COPY INTO

  B. CREATE PIPE

  C. INSERT INTO

  D. TABLE STREAM

  Correct Answer: B

• Question 54:

  Which TABLE function helps to convert semi-structured data to a relational representation?

  A. CHECK_JSON

  B. TO_JSON

  C. FLATTEN

  D. PARSE_JSON

  Correct Answer: C

  https://docs.snowflake.com/en/sql-reference/functions/flatten.html

• Question 55:

  Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

  B. Allows a user to import the files in a sequential order

  C. Increases the latency staging and accuracy when loading the data

  D. Allows optimization of parallel operations

  Correct Answer: D

• Question 56:

  Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

• Question 57:

  Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  A. UPDATE TABLE FROM STREAM

  B. SELECT FROM STREAM

  C. INSERT INTO TABLE SELECT FROM STREAM

  D. ALTER TABLE AS SELECT FROM STREAM

  E. BEGIN COMMIT

  Correct Answer: AC

• Question 58:

  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

  Correct Answer: D

• Question 59:

  Which statement is true about running tasks in Snowflake?

  A. A task can be called using a CALL statement to run a set of predefined SQL commands.

  B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

  C. A task allows a user to execute a set of SQL commands on a predefined schedule.

  D. A task can be executed using a SELECT statement to run a predefined SQL command.

  Correct Answer: B

• Question 60:

  What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

  A. Row level access policies

  B. Data masking policies

  C. Data encryption

  D. Time Travel

  E. External tokenization

  Correct Answer: CD