Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 641:

  The FLATEEN function is used to query which type of data in Snowflake?

  A. Structured data

  B. Semi-structured data

  C. Both of the above

  D. None of the above

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html

  FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.

• Question 642:

  Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

  A. Their default role should be set to SYSTEMADMIN (the lower of the two)

  B. They should not set up multi_Factor Authentication (MFA)--as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

  C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

  D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

  E. They should use the SYSADMIN role to perform administrative work on database objects

  Correct Answer: ACE

• Question 643:

  What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

  A. On-premise availability

  B. Simplicity

  C. Open source based

  D. Concurrency

  E. Performance

  Correct Answer: BDE

• Question 644:

  True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

  A. True

  B. False

  Correct Answer: A

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

• Question 645:

  The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

  A. The complexity of each query

  B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

  C. The size of the data required for each query

  D. The tool that s executing the query

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 646:

  True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

• Question 647:

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

  A. True

  B. False

  Correct Answer: B

• Question 648:

  Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

  A. Database

  B. Tables

  C. Warehouses

  D. Worksheets

  Correct Answer: ACD

  Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html

• Question 649:

  True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 650:

  When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: Select one.

  A. Concurrency

  B. Performance

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance