SnowPro Advanced: Architect Free Practice Exam Questions

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

  1. Question 133: Database DB1 has schema S1 which has one table, T1: DB1 --> S1 --> T1 - The retention period of DB1 is set to 10 days. The retention period of S1 is set to 20…
  2. Question 134: What considerations should be taken into account when deciding which method to use to load data into Snowflake? (Choose three.)
  3. Question 135: A company that is new to Snowflake is able to connect to its account using SnowSQL, but receives the following error message in the connection logs: SEVERE: WA…
  4. Question 136: Which parameters can only be set at the account level? (Choose two.)
  5. Question 138: The company, myorg, has multiple Snowflake accounts. An Architect found one of the accounts, account1, does not have replication enabled. Executing which query…
  6. Question 139: In a managed access schema, what are characteristics of the roles that can manage object privileges? (Choose two.)
  7. Question 140: An Architect notes that a large table is having poor query performance. The Query Profile shows that the table is accessed by multiple teams within the company…
  8. Question 141: A table, contacts_data, is created and data is inserted into it: create table contacts_data (c object); Insert into contacts_data - select parse_json (' { "cus…
  9. Question 142: How does Snowflake handle replication for source and target accounts that have Tri-Secret Secure enabled? (Choose two.)
  10. Question 143: What occurs when unloading data from Snowflake? (Choose two.)