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

1. A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = 'JDOE' DEFAULT ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

A) Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
B) Set up future grants on the newly-created schemas.
C) Set up the new schema as a managed-access schema.
D) Assign ownership privilege to DEV_TEAM on the newly-created schema.

2. What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

A) The account name must be unique within the organization.
B) The account name must be specified when the account is created.
C) The account name must be unique among all Snowflake customers.
D) The account name is immutable and cannot be changed.
E) The account requires at least one ORGADMIN role within one of the organization's accounts.

3. 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) Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
B) No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
C) No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
D) Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

4. An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

A) select * from LINEITEM sample bernoulli (20);
B) select * from LINEITEM tablesample system (20) seed (1);
C) select * from LINEITEM sample system (20);
D) select * from LINEITEM tablesample block (20 rows);

5. MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Choose three.)

A) SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);
B) SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
C) SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
D) SELECT * FROM my_table AT(OFFSET => -60*30);
E) SELECT * FROM my_table WITH TIME TRAVEL(OFFSET => -60*30);
F) SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);

질문과 대답: