SnowPro Core v1.0 (SnowPro Core)

Page:    1 / 72   
Total 1078 questions

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  • A. Configure the Maximum Clusters setting to ג€Auto-Scaleג€
  • B. Set the Warehouse type to ג€Autoג€
  • C. Set the Minimum Clusters and Maximum Clusters settings to the same value
  • D. Set the Minimum Clusters and Maximum Clusters settings to the different values


Answer : D

Reference:
https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

Which of the following terms best describes Snowflake's database architecture?

  • A. Columnar shared nothing
  • B. Shared disk
  • C. Multi-cluster, shared data
  • D. Cloud-native shared memory


Answer : B

Reference:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Which of the following are options when creating a Virtual Warehouse? (Choose two.)

  • A. Auto-drop
  • B. Auto-resize
  • C. Auto-resume
  • D. Auto-suspend


Answer : CD

Reference:
https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  • A. The primary cluster in the Virtual Warehouse
  • B. The entire Virtual Warehouse
  • C. The database the Virtual Warehouse resides in
  • D. The queries currently being run by the Virtual Warehouse


Answer : B

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

Fail-safe is unavailable on which table types? (Choose two.)

  • A. Temporary
  • B. Transient
  • C. Provisional
  • D. Permanent


Answer : AB

Reference:
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

Which of the following objects is not covered by Time Travel?

  • A. Tables
  • B. Schemas
  • C. Databases
  • D. Stages


Answer : D

Reference:
https://docs.snowflake.com/en/user-guide/data-time-travel.html

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  • A. True
  • B. False


Answer : A

Reference:
https://blog.ippon.tech/innovative-snowflake-features-caching/

Which of the following commands are not blocking operations? (Choose two.)

  • A. UPDATE
  • B. INSERT
  • C. MERGE
  • D. COPY


Answer : BD

Which of the following is true of Snowpipe via REST API? (Choose two.)

  • A. You can only use it on Internal Stages
  • B. All COPY INTO options are available during pipe creation
  • C. Snowflake automatically manages the compute required to execute the Pipeג€™s COPY INTO commands
  • D. Snowpipe keeps track of which files it has loaded


Answer : BD

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

  • A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
  • B. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
  • C. SECURITYADMIN, ACCOUNTADMIN
  • D. ACCOUNTADMIN


Answer : D

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

When can a Virtual Warehouse start running queries?

  • A. 12am-5am
  • B. Only during administrator defined time slots
  • C. When its provisioning is complete
  • D. After replication


Answer : B

True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  • A. True
  • B. False


Answer : B

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

True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

  • A. True
  • B. False


Answer : B

True or False: Pipes can be suspended and resumed.

  • A. True
  • B. False


Answer : B

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

Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

  • A. Java
  • B. Javascript
  • C. SQL
  • D. Python


Answer : BC

Reference:
https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

Page:    1 / 72   
Total 1078 questions