【2026年备考题库】SnowPro Advanced Architect SnowPro认证题库_在线真题试卷与模拟练习_【2026年备考题库】SnowPro Advanced Architect SnowPro认证题库_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write Access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel. An Architect needs to create a read-only role for certain employees working in the human resources department. Which permission sets must be granted to this role?

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within The data share by the consumers. What is the recommended way to validate data accessibility by the consumers?

How does a standard virtual warehouse policy work in Snowflake?

Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Choose two.)

A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in The same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis. After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day. What would cause this to occur? (Choose two.)

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 Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

Topic 1

The following DDL command was used to create a task based on a stream:

（含图）

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is Considering Using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?

A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the Allowed time travel period or before the object creation time. The Architect then checks the schema history and sees the following: CREATED_ON|NAME|DROPPED_ON -2021.-06-02 23:00:00 | STAGING | NULL2021.-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00 How can cloning the STAGING schema be achieved?

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

Topic 1

An Architect entered the following commands in sequence:

（含图）

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose

Two.)

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Choose two.)

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using Cloning and Time Travel. What command will accomplish this?

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)