SnowPro Advanced: Architect Free Practice Exam Questions

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

Question 103: A new user user_01 is created within Snowflake. The following two commands are executed: Command 1 --> show grants to user user_01; Command 2 --> show grants o…
Question 104: A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AW…
Question 105: A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of…
Question 106: An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an inges…
Question 107: A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables. How should the database…
Question 108: Company A has recently acquired company B. The Snowflake deployment for company B is located in the Azure West Europe region. As part of the integration proces…
Question 109: A table, T1, has a table stream defined, named S1. The data retention time on the table is set for 10 days. Stream S1has not been consumed for 10 consecutive d…
Question 110: Instead of updating a particular row, a user forgot to put in the where clause and accidentally updated the entire table, named customer. The variable error_up…
Question 111: A company is implementing a machine learning use case on a very large data set which will require high volumes of memory and compute resources. How should this…
Question 112: A Snowflake Architect anticipates that a table will contain several terabytes of data, and so defines a custom cluster key of three columns to optimize query p…