Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 661:

  What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

  A. Installing and configuring hardware

  B. Patching software

  C. Physical security

  D. Maintaining metadata and statists

  Correct Answer: ABD

• Question 662:

  For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

  A. The number of queries that ran using the Warehouse.

  B. The size of the Warehouse and the number of clusters that ran within a given time period.

  C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

  D. The number of users who accessed the Warehouse.

  Correct Answer: B

• Question 663:

  True or False: Once created, a micro-partition will never be changed.

  A. True

  B. False

  Correct Answer: A

  Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

• Question 664:

  Which of the following statements are true of Snowflake releases: (Choose two.)

  A. They happen approximately weekly

  B. They roll up and release approximately monthly, but customers can request early release application

  C. During a release, new customer requests/queries/connections transparently move over to the newer version

  D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

  Correct Answer: AC

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

• Question 665:

  Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)? Choose 2 answers

  A. SnowSQL

  B. ODBC

  C. R

  D. HIVE

  Correct Answer: AB

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

• Question 666:

  Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  A. Customers can change the size of the Warehouse after creation

  B. A Warehouse can be resized while running

  C. A Warehouse can be configured to suspend after a period of inactivity

  D. A Warehouse can be configured to auto-resume when new queries are submitted

  Correct Answer: ABCD

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

• Question 667:

  Which statement best describes '' clustering''?

  A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

  B. The database administrator must define the clustering methodology for each Snowflake table.

  C. The clustering key must be included on the COPV command when loading data into Snowflake.

  D. Clustering can be disabled within a Snowflake account.

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

• Question 668:

  True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

• Question 669:

  How a Snowpipe charges calculated?

  A. Per-second/per Warehouse size

  B. Per-second/per-core granularity

  C. Number of Pipes in account

  D. Total storage bucket size

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

• Question 670:

  The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  A. 60 minutes

  B. 24 hours

  C. 14 days

  D. 30 days

  E. 1 year

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html