SnowPro Advanced: Architect Free Practice Exam Questions

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

Question 113: A company needs to set up Snowflake with the ability to use zero-copy cloning from a production environment to keep data fresh in development and QA environmen…
Question 114: A company has two Snowflake accounts, one for production and another for non-production. The accounts are located in different cloud provider regions. The comp…
Question 115: An Architect is investigating a performance issue with an existing architecture and found a query where the Query Profile indicates a high number of bytes spil…
Question 116: An Architect created a database using the role DB_OWNER and a schema with managed access within this database using the role SCHEMA_OWNER. The team created a t…
Question 117: An Architect is designing a data pipeline that processes JSON data from an untrusted source into Snowflake. The pipeline needs to handle instances where the in…
Question 118: An Architect has a DEV and PROD schema within a database. The DEV schema is used to create all objects with the correct permissions before promoting to the PRO…
Question 119: Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?
Question 120: A user creates table T1 in schema S1. The user immediately realizes that they left off a column in the table. Using the same role, the user runs this command:…
Question 121: The result cache is not being used on the following query: select * from ORDERS Where O_ORDERDATE = date_trunc('day', current_timestamp()); The query is run hu…
Question 122: Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?