SnowPro Advanced: Architect Free Practice Exam Questions

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

  1. Question 1: At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?
  2. Question 2: How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
  3. Question 3: An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.c…
  4. Question 4: Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
  5. Question 5: What are some of the characteristics of result set caches? (Choose three.)
  6. Question 6: A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running…
  7. Question 7: What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
  8. Question 8: When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
  9. Question 9: A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Archi…
  10. Question 10: Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)