Snowflake pro core 80 Qst part 1.2

Snowflake provides a mechanism for its customer to override its natural clustering algorithms. This method is

• Micro-Partitions

• Clustering Keys

• Key partitions

• Clustered partitions

True or False: A single database can exist in more than one Snowflake account.

• True

• False

Which of the following roles is recommended to be used to create and manage users and roles?

• SYSADMIN

• SECURITYADMIN

• PUBLIC

• ACCOUNTADMIN

True or False: A customer using SnowSQL/native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support

• True

• False

Account-level storage usage can be monitored via:

• The Snowflake Web Interface (UI) in the Databases section

• The Snowflake Web interface (UI) in the Account->Billing & Usage section

• The Information Schema -> Account_Usage_History View

• The Account Usage Schema -> Account_Usage_metrics View

True or False: The COPY command must specify a File Format in order to execute

• True

• False

What are the three layers that make up Snowflake's architecture? (Choose three)

• Compute

• Tri-Secret secure

• Storage

• Cloud Services

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

• To accommodate more queries

• To accommodate more users

• To accommodate Fluctuations in workload

• to accommodate a more complex workload

True or False: Reader accounts incur no additional Compute cost to the data provider since they are simply reading the shared data without making changes

• True

• False

True or False: Snowflake charges a premium for storing semi-structured data

• True

• False