What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

• A.Single Sign-On (SSO)
• B.OAuth
• C.Duo Security
• D.Okta

Comment: *

Name: *

Email: *

Verification: *

Which data types optimally store semi-structured data? (Select TWO).

• A.VARIANT
• B.CHARACTER
• C.VARCHAR
• D.ARRAY
• E.STRING

Comment: *

Name: *

Email: *

Verification: *

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

• A.Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
• B.Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
• C.Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
• D.Scaling out adds clusters of varying sizes to a virtual warehouse.
• E.Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
• F.Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The size of the data required for each query
• B.The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
• C.The tool that s executing the query
• D.The complexity of each query

Comment: *

Name: *

Email: *

Verification: *

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

• A.GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• B.GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• C.ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• D.GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Comment: *

Name: *

Email: *

Verification: *