SnowPro Advanced: Architect Free Practice Exam Questions

176 real SnowPro Advanced: Architect exam questions with answers and AI explanations. Snowflake certification prep — page 5 of 18.

  1. Question 45: Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
  2. Question 46: An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?
  3. Question 47: A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity,…
  4. Question 48: A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are…
  5. Question 49: What Snowflake features should be leveraged when modeling using Data Vault?
  6. Question 50: An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50…
  7. Question 51: What are purposes for creating a storage integration? (Choose three.)
  8. Question 52: There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company re…
  9. Question 54: A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging…
  10. Question 55: A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given h…