Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 491:

  How can a Snowflake user load duplicate files with a COPY INTO command?

  A. The COPY INTO options should be set to PURGE = FALSE

  B. The COPY INTO options should be set to FORCE = TRUE

  C. The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE

  D. The COPY INTO options should be set to ON_ERROR = CONTINUE

  Correct Answer: B

• Question 492:

  What causes objects in a data share to become unavailable to a consumer account?

  A. The DATA_RETENTION_TIME_IN_DAYS parameter in the consumer account is set to 0.

  B. The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.

  C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

  D. The consumer account acquires the data share through a private data exchange.

  Correct Answer: C

• Question 493:

  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

  Correct Answer: A

• Question 494:

  Which command is used to unload data from a table or move a query result to a stage?

  A. COPY INTO

  B. GET

  C. MERGE

  D. PUT

  Correct Answer: A

• Question 495:

  What privileges are necessary for a consumer in the Data Exchange to make a request and receive data? (Choose two.)

  A. CREATE DATABASE

  B. IMPORT SHARE

  C. OWNERSHIP

  D. REFERENCE_USAGE

  E. USAGE

  Correct Answer: AB

• Question 496:

  What are benefits of using Snowpark with Snowflake? (Choose two.)

  A. Snowpark uses a Spark engine to generate optimized SQL query plans.

  B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.

  C. Snowpark does not require that a separate cluster be running outside of Snowflake.

  D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

  E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

  Correct Answer: CD

• Question 497:

  What are Snowflake best practices when assigning the ACCOUNTADMIN role to users? (Choose two.)

  A. The ACCOUNTADMIN role should be assigned to at least two users.

  B. The ACCOUNTADMIN role should be used to create Snowflake objects.

  C. The ACCOUNTADMIN role should be used for running automated scripts.

  D. The ACCOUNTADMIN role should be given to any user who needs a high level of authority.

  E. All users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).

  Correct Answer: AE

• Question 498:

  What is a recommended approach for optimizing query performance in Snowflake?

  A. Use subqueries whenever possible.

  B. Use a large number of joins to combine data from multiple tables.

  C. Select all columns from tables, even if they are not needed in the query.

  D. Use a smaller number of larger tables rather than a larger number of smaller tables.

  Correct Answer: D

• Question 499:

  When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? (Choose two.)

  A. echo

  B. quiet

  C. output_file

  D. output_format

  E. force_put_overwrite

  Correct Answer: CD

• Question 500:

  How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

  A. A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

  B. A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

  C. A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

  D. Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

  Correct Answer: B