Which Snowflake data modeling approach is designed for BI queries?

• A. Data Vault
• B. 3 NF
• C. Star schema
• D. Snowflake schema

What are purposes for creating a storage integration? (Choose three.)

• A. Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
• B. Support multiple external stages using one single Snowflake object.
• C. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
• D. Manage credentials from multiple cloud providers in one single Snowflake object.
• E. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider' s key management service.
• F. Avoid supplying credentials when creating a stage or when loading or unloading data.

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.
The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.
Which is the LEAST complex approach to use to populate the QA account with the Production account's data and database objects on a nightly basis?

• A. 1) Create a share in the Production account for each database2) Share access to the QA account as a Consumer3) The QA account creates a database directly from each share4) Create clones of those databases on a nightly basis5) Run tests directly on those cloned databases
• B. 1) In the Production account, create an external function that connects into the QA account and returns all the data for one specific table2) Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account
• C. 1) Enable replication for each database in the Production account2) Create replica databases in the QA account3) Create clones of the replica databases on a nightly basis4) Run tests directly on those cloned databases
• D. 1) Create a stage in the Production account2) Create a stage in the QA account that points to the same external object-storage location3) Create a task that runs nightly to unload each table in the Production account into the stage4) Use Snowpipe to populate the QA account

An Architect wants to use clustering keys to improve table performance.
What should the Architect consider? (Select THREE).

• A. Clustering keys are only recommended for tables larger than 1 GB.
• B. Clustering keys are designed to co-locate data within micro-partitions.
• C. A high value returned by SYSTEM$CLUSTERING_DEPTH indicates good clustering.
• D. Snowflake can cluster a materialized view to tailor for specific queries.
• E. Clustering has a storage and compute cost.
• F. Snowflake recommends a maximum of five clustering keys.

A user can change object parameters using which of the following roles?

• A. ACCOUNTADMIN, SECURITYADMIN
• B. ACCOUNTADMIN, USER with PRIVILEGE
• C. SECURITYADMIN, USER with PRIVILEGE
• D. SYSADMIN, SECURITYADMIN