SP Study

If there was a requirement to provide an additional 7 days of disaster recovery of historical data by Snowflake beyond the Time Travel period, which types of table(s) would provide this ability?

• Permanent and transient tables

• 
  Permanent, transient, and temporary

• 
  Transient and temporary

• 
  External and permanent

• Just permanent

Which groups of SQL statements will run successfully in Snowsight? (Choose 2)

• 
  CREATE INDEX and DROP INDEX

• CREATE USER, ALTER USER and DROP USER

• CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE

• 
  CREATE SERVER, ALTER SERVER and DROP SERVER

• 
  CREATE WAREHOUSE, ALTER WAREHOUSE and DROP WAREHOUSE

Virtual warehouses provide which capabilities in a Snowflake session? (Choose 3)

• Retrieving rows from tables and views

• Performing DML operations such as DELETE, INSERT, and UPDATE

• Managing metadata

• 
  Parsing and optimizing queries

• Loading and unloading data to and from tables (COPY INTO)

Select Snowflake partner categories that are listed in the Snowflake Ecosystem. (Choose all that apply.)

• Security, Governance, and Observability

• 
  ML and Data Science

• OEM

• Data Integration

• 
  Business Intelligence

Which partner category in the Snowflake ecosystem generally encompasses data preparation and data warehouse automation in addition to data transformation?

• 
  SQL Development and Management

• Business Intelligence

• Data Integration

• Native Programmatic Interfaces

When planning to use a Partner Connect trial account, what should be part of your process to ramp up with the partner trial? (Choose 2)

• As long as you know the terms and conditions for one Partner Connect trial, the other partner agreements should be the same because Snowflake determines the conditions and terms for consistency across partners.

• 
  Once logged on, any Snowflake user can use the Partner Connect feature.

• 
  You must specify one or more databases, either during initial connection, or later using a manual process.

• 
  You can quickly start a trial account of the Partner Connect vendor from within the Snowflake UI.

Select the connectors and drivers provided by Snowflake. (Choose 4)

• Node.js

• 
  ODBC

• 
  Partner Connect

• Python

• Spark

Which statements are true of Continuous Data Protection in Snowflake? (Choose 3)

• The view TABLE_STORAGE_METRICS lets you query physical storage (in bytes) for table data in Active, Time Travel, and Fail-safe states.

• Continuous Data Protection (CDP) includes Time Travel and Fail-safe.

• You can monitor data storage across your account using the SYSADMIN role.

• All ingested data in Snowflake tables, as well as internal stages (for data loading/unloading operations), is encrypted using AES-256 strong encryption.

You want to block certain IP addresses from establishing a connection to your Snowflake account. Which mechanism would you use?

• Create a firewall policy and attach to the account

• Create a network policy and attach to the account

• Create a firewall policy and attach to every user in the account

• Create a network policy and attach to every user in the account

• Snowflake does not support blocking by IP addresses

USER_A claims their account is locked out. You want to review recent authentication attempts using USER_A. Where would you look?

• Download the logs using the SnowSQL CLI command GET /var/log/messages

• SELECT * FROM V$LOG

• SELECT * FROM SNOWFLAKE.LOGGING.LOGIN_HISTORY

• SELECT * FROM INFORMATION_SCHEMA.LOGIN_HISTORY

• SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY