SnowPro-Advanced-Architect Exam - Free Sample Questions & Answers
Preparing for the SnowPro-Advanced-Architect exam is simple with Certs Blitz. We offer easy-to-understand study materials that help you learn the most important exam topics. You can study using our PDF questions, practice online with a real exam-style test, or use the desktop practice software. Choose the study method that works best for you and prepare at your own pace.
At Certs Blitz, we keep our SnowPro-Advanced-Architect practice questions up to date. Whenever the exam syllabus or objectives change, we update our study materials so you always learn the latest topics. This helps you save time, avoid outdated content, and feel more confident when you take your exam.
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
Correct Answer: A, B, D, F
AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use BROTLI instead of AUTO. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv
Which statement is not true about shared database?
Correct Answer: D
General Limitations for Shared Databases Shared databases have the following limitations for consumers: Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Shared databases and all the objects in the database cannot be forwarded (i.e. re-shared with other accounts). https://docs.snowflake.com/en/user-guide/data-share-consumers.html#general-limitations-for- shareddatabases
Select the true statements about TASKS
Correct Answer: A, B, D
How do you refresh a materialized view?
Correct Answer: C
Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view after changes are made to the base table. This is more efficient and less error-prone than manually maintaining the equivalent of a materialized view at the application level. https://docs.snowflake.com/en/user-guide/views-materialized.html#when-to-use-materialized-views
Which Snowflake objects can be used in a data share? (Select TWO).
Correct Answer: B, D
https://docs.snowflake.com/en/user-guide/data-sharing-intro