Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 531:

  What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

  A. Reorder the rows in a relational table and then unload the rows into a file.

  B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

  C. Reorder the data columns according to a target table definition and then unload the rows into the table.

  D. Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.

  Correct Answer: B

• Question 532:

  Which key governance feature in Snowflake allows users to identify data objects that contain sensitive data and their related objects?

  A. Object tagging

  B. Data classification

  C. Row access policy

  D. Column-level security

  Correct Answer: A

• Question 533:

  What can a Snowflake user do in the Admin area of Snow right?

  A. Analyze query performance.

  B. Write queries and execute them.

  C. Provide an overview of the listings in the Snowflake Marketplace.

  D. Connect to Snowflake partners to explore extended functionality.

  Correct Answer: D

• Question 534:

  When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

  A. There are multiple SQL UDFs with the same names and the same number of arguments.

  B. There are multiple SQL UDFs with the same names and the same number of argument types.

  C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

  D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.

  Correct Answer: C

• Question 535:

  A user is unloading data to a stage using this command:

  copy into @message from (select object_construct('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman')) file_format = (type = json)

  What will the output file in the stage be?

  A. A single compressed JSON file with a single VARIANT column

  B. Multiple compressed JSON files with a single VARIANT column

  C. A single uncompressed JSON file with multiple VARIANT columns

  D. Multiple uncompressed JSON files with multiple VARIANT columns

  Correct Answer: A

• Question 536:

  A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

  How can this be achieved?

  A. Flatten the data and store it in structured data types in a flattened table. Query the table.

  B. Store the data in a table with a VARIANT data type. Query the table.

  C. Store the data in a table with a VARIANT data type and include STRIP_NULL_VALUES while loading the table. Query the table.

  D. Store the data in an external stage and create views on top of it. Query the views.

  Correct Answer: A

• Question 537:

  There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production.

  How can data be easily transferred from the production account to the non-production account?

  A. Clone the data from the production account to the non-production account.

  B. Create a data share from the production account to the non-production account.

  C. Create a subscription in the production account and have it publish to the non-production account.

  D. Create a reader account using the production account and link the reader account to the non-production account.

  Correct Answer: A

• Question 538:

  Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?

  A. Pruning

  B. Spilling

  C. Join explosion

  D. Queue overloading

  Correct Answer: B

• Question 539:

  At what levels can a resource monitor be configured? (Choose two.)

  A. Account

  B. Database

  C. Organization

  D. Schema

  E. Virtual warehouse

  Correct Answer: AE

• Question 540:

  What activities can be monitored by a user directly from Snowsight's Activity tab without using the Account_Usage views? (Choose two.)

  A. Login history

  B. Query history

  C. Copy history

  D. Event usage history

  E. Virtual warehouse metering history

  Correct Answer: BC