Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 731:

  Which data type can be used to store geospatial data in Snowflake?

  A. Variant

  B. Object

  C. Geometry

  D. Geography

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

• Question 732:

  Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Compute layer

  B. Storage layer

  C. Cloud infrastructure layer

  D. Cloud services layer

  Correct Answer: D

• Question 733:

  True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  A. True

  B. False

  Correct Answer: B

  By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

• Question 734:

  True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 735:

  Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

  A. SCIM

  B. Federated authentication

  C. TLS 1.2

  D. Key-pair authentication

  E. OAuth

  F. OCSP authentication

  Correct Answer: BDE

• Question 736:

  What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

  A. Informatica

  B. Power Bl

  C. Adobe

  D. Data Robot

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

• Question 737:

  Which feature is only available in the Enterprise or higher editions of Snowflake?

  A. Column-level security

  B. SOC 2 type II certification

  C. Multi-factor Authentication (MFA)

  D. Object-level access control

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 738:

  What is the minimum Snowflake edition required to create a materialized view?

  A. Standard Edition

  B. Enterprise Edition

  C. Business Critical Edition

  D. Virtual Private Snowflake Edition

  Correct Answer: B

  Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

• Question 739:

  Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  A. VARIANT

  B. ARRAY

  C. VARCHAR

  D. XML

  E. BLOB

  Correct Answer: AB

  https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

  A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

  The maximum length of a VARIANT is 16 MB.

  A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

• Question 740:

  During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  A. STATEMENT_TIMEOUT__IN__SECONDS

  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  C. MAX_CONCURRENCY__LEVEL

  D. QUERY_TIMEOUT_IN_SECONDS

  Correct Answer: B

  The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter% 20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.