Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 581:

  Which REST API can be used with unstructured data?

  A. insertFiles

  B. insertReport

  C. GET /api/files/

  D. loadHistoryScan

  Correct Answer: C

• Question 582:

  Which command is used to unload files from an internal or external stage to a local file system?

  A. COPY INTO

  B. GET

  C. PUT

  D. TRANSFER

  Correct Answer: B

• Question 583:

  A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

  A. ROW_NUMBER

  B. TABLE

  C. TABULAR

  D. VALUES

  Correct Answer: B

• Question 584:

  Which SQL statement will require a virtual warehouse to run?

  A. SELECT COUNT(*) FROM TBL_EMPLOYEE;

  B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);

  C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance

  Correct Answer: C

• Question 585:

  Which Snowflake object can be created to be temporary?

  A. Role

  B. Stage

  C. User

  D. Storage integration

  Correct Answer: B

• Question 586:

  Which stream type can be used for tracking the records in external tables?

  A. Append-only

  B. External

  C. Insert-only

  D. Standard

  Correct Answer: C

• Question 587:

  What is the recommended approach for unloading data to a cloud storage location from Snowflake?

  A. Use a third-party tool to unload the data to cloud storage.

  B. Unload the data directly to the cloud storage location.

  C. Unload the data to a local file system, then upload it to cloud storage.

  D. Unload the data to a user stage, then upload the data to cloud storage

  Correct Answer: B

• Question 588:

  Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

  A. Resource monitor

  B. Account_usage.query_history

  C. Information_schema.warehouse_load_history

  D. Information_schema.warehouse_metering_history

  Correct Answer: D

• Question 589:

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

  A. CSV

  B. JSON

  C. ORC

  D. Parquet

  Correct Answer: D

• Question 590:

  A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

  A. ARRAY

  B. OBJECT

  C. TEXT

  D. VARIANT

  Correct Answer: D