최신Snowflake SnowPro Advanced Administrator ADA-C02 - ADA-C02무료샘플문제
문제1
An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?
An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
Which tasks can be performed by the ORGADMIN role? (Choose three.)
Which tasks can be performed by the ORGADMIN role? (Choose three.)
정답: A,C,D
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?
Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
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 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?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
What SCIM integration types are supported in Snowflake? (Choose three.)
What SCIM integration types are supported in Snowflake? (Choose three.)
정답: A,C,F
설명: (KoreaDumps 회원만 볼 수 있음)