다운로드 Snowflake : ADA-C01 질문 & 답 PDF & Test Software

실제 시험과 비슷한 환경에서 연습해 보신 적이 있으신가요? PassTIP의 Snowflake SnowPro Advanced Administrator 테스트 엔진은 ADA-C01 시험 환경을 재현해 실전 감각을 길러 줍니다.

Snowflake ADA-C01 시험 개요:

Snowflake ADA-C01 시험 요강 주제:

ADA-C01 시험, 수험생이 가장 많이 묻는 질문

최신 SnowPro Advanced: Administrator ADA-C01 무료샘플문제

문제 #1

What are benefits of using Snowflake organizations? (Select TWO).

A. Administrators can monitor and understand usage across all accounts in the organization.
B. Administrators can simplify data movement across all accounts within the organization.
C. Administrators have the ability to create accounts in any available cloud provider or region.
D. Administrators can change Snowflake account editions on-demand based on need.
E. User administration is simplified across all accounts within the organization.

문제 #2

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

A. Adding region availability to the listing
B. Dropping a column from a table
C. Renaming a table
D. Deleting data from a table
E. Unpublishing the data listing

문제 #3

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

A. CREATE NETWORK POLICY ADMIN POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';
B. CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
C. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED IP LIST = ('192.168.1.100')
BLOCKED_IP_LIST = ('0.0.0.0/0');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
D. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
User ABC is the only user with an ACCOUNTADMIN role.

문제 #4

A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region.
When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?

A. create or replace row access policy region policy as (region_value varchar) returns boolean -> exists ( select 1 from entitlement_table where role = current_role () and region = region_value )
B. create or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL ACCESS_ROLE' = current_role ()
and exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)
C. create or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL ACCESS ROLE' = current_role ()
)
D. create or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL_ACCESS_ROLE' = current_role ()
or exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

문제 #5

A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL:

Given that the combined total of credits consumed by fin_wh1 and fin_wh2 (including cloud services) has reached 800 credits and both warehouses are suspended, what should the ACCOUNTADMIN execute to allow both warehouses to be resumed? (Select TWO).

A. ALTER WAREHOUSE fin_wh1 RESUME;
B. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;
C. ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;
D. ALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
E. ALTER WAREHOUSE fin_wh2 RESUME;
F. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;
G. ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

질문과 대답: