[2026] Snowflake SnowPro Advanced Administrator

문제1

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

A. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

B. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

C. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제2

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

A. Create it as an external table, which will not incur Time Travel costs.

B. Create it as a temporary table with a retention time of 0 days.

C. Create it as a transient table with a retention time of 0 days.

D. Create it as a permanent table with a retention time of 0 days.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제3

What are characteristics of Dynamic Data Masking? (Select TWO).

A. The role that creates the masking policy will always see unmasked data in query results.

B. A single masking policy can be applied to columns in different tables.

C. A masking policy can be applied to the VALUE column of an external table.

D. A masking policy that is currently set on a table can be dropped.

E. A single masking policy can be applied to columns with different data types.

정답: B,E

설명: (Fast2test 회원만 볼 수 있음)

문제4

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

A. Implement views on top of base tables that exclude or mask sensitive data.

B. Use a third-party tool to share the data.

C. Include masking rules as part of data ingestion and transformation pipelines.

D. Use zero-copy cloning to replicate the database schema and provide access as needed.

E. Implement row access policies and Dynamic Data Masking policies.

정답: A,E

설명: (Fast2test 회원만 볼 수 있음)

문제5

How should an Administrator configure a Snowflake account to use AWS PrivateLink?

A. Create CNAME records in the DNS.

B. Use SnowCD to evaluate the network connection.

C. Block public access to Snowflake.

D. Contact Snowflake Support.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제6

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

A. alter user userl set DISABLE_MFA=1440;

B. alter user userl set HOURS_TO_BYPASS_MFA=24;

C. alter user userl set MINS_TO_BYPASS_MFA=1440;

D. alter user userl set TEMPORARY_MFA_BYPASS=1440;

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제7

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

A. Renaming a table

B. Adding region availability to the listing

C. Deleting data from a table

D. Unpublishing the data listing

E. Dropping a column from a table

정답: A,E

설명: (Fast2test 회원만 볼 수 있음)

문제8

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

A. Manage system grants

B. Reset a Snowflake user's password

C. Create new users

D. Create new roles

정답: A

설명: (Fast2test 회원만 볼 수 있음)

Snowflake SnowPro Advanced Administrator - ADA-C01무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트