SnowPro Advanced Architect Practice Test

SnowPro Advanced Architect Practice Test practice questions, page 10 of 10, with answer review and explanations.

Question 46

A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?

  1. The company must have a Snowflake account in each cloud region to be able to ingest data to that account.
  2. The company must replicate data between Snowflake accounts.
  3. The company should provision a reader account to each site and ingest the data through the reader accounts.
  4. The company should use a storage integration for the external stage.

Question 47

What Snowflake features should be leveraged when modeling using Data Vault?

  1. Snowflake’s support of multi-table inserts into the data model’s Data Vault tables
  2. Data needs to be pre-partitioned to obtain a superior data access performance
  3. Scaling up the virtual warehouses will support parallel processing of new source loads
  4. Snowflake’s ability to hash keys so that hash key joins can run faster than integer joins

Question 48

A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

  1. 1. OAuth (either Snowflake OAuth or External OAuth) 2. External browser 3. Okta native authentication 4. Key Pair Authentication, mostly used for service account users 5. Password
  2. 1. External browser, SSO 2. Key Pair Authentication, mostly used for development environment users 3. Okta native authentication 4. OAuth (ether Snowflake OAuth or External OAuth) 5. Password
  3. 1. Okta native authentication 2. Key Pair Authentication, mostly used for production environment users 3. Password 4. OAuth (either Snowflake OAuth or External OAuth) 5. External browser, SSO
  4. 1. Password 2. Key Pair Authentication, mostly used for production environment users 3. Okta native authentication 4. OAuth (either Snowflake OAuth or External OAuth) 5. External browser, SSO

Question 49

What is a valid object hierarchy when building a Snowflake environment?

  1. Account --> Database --> Schema --> Warehouse
  2. Organization --> Account --> Database --> Schema --> Stage
  3. Account --> Schema > Table --> Stage
  4. Organization --> Account --> Stage --> Table --> View

Question 50

Which of the following are characteristics of Snowflake’s parameter hierarchy?

  1. Session parameters override virtual warehouse parameters.
  2. Virtual warehouse parameters override user parameters.
  3. Table parameters override virtual warehouse parameters.
  4. Schema parameters override account parameters.