Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 571:

  Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL

  B. GET_ABSOLUTE_PATH

  C. GET_RELATIVE_PATH

  D. GET_STAGE_LOCATION

  Correct Answer: A

• Question 572:

  A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.

  Which set operator should be used?

  A. INTERSECT

  B. MERGE

  C. MINUS

  D. UNION

  Correct Answer: A

• Question 573:

  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.

  Correct Answer: B

• Question 574:

  Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

  A. Data classification

  B. Query acceleration service

  C. Search optimization service

  D. Tagging

  Correct Answer: C

• Question 575:

  When can user session variables be accessed in a Snowflake scripting procedure?

  A. When the procedure is defined as STRICT.

  B. When the procedure is defined to execute as CALLER.

  C. When the procedure is defined to execute as OWNER.

  D. When the procedure is defined with an argument that has the same name and type as the session variable.

  Correct Answer: B

• Question 576:

  What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

  A. Swift

  B. JavaScript

  C. Python

  D. SQL

  Correct Answer: C

• Question 577:

  A user needs to ingest 1 GB of data that is available in an external stage using a COPY INTO command.

  How can this be done with MAXIMUM performance and the LEAST cost?

  A. Ingest the data in a compressed format as a single file.

  B. Ingest the data in an uncompressed format as a single file.

  C. Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.

  D. Split the file into smaller files of 100-250 MB each and ingest each of the smaller files in an uncompressed format.

  Correct Answer: C

• Question 578:

  Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

  A. Authy

  B. Duo Security

  C. One Login

  D. RSA SecurID Access

  Correct Answer: B

• Question 579:

  In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

  A. Cloud Services

  B. Database Storage

  C. Query Processing

  D. Metadata Management

  Correct Answer: B

• Question 580:

  Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

  A. list @bronzestage;

  B. select * from directory(@bronzestage);

  C. select metadata$filename from @bronzestage;

  D. select * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));

  Correct Answer: B