Snowflake인증 실제 시험문제, ADA-C02 덤프문제집

문제1
A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name: VWH_META
Column 1: SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2: CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH_META?

A. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));

B. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));

C. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

D. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
OBJECT_CONSTRUCT(*)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

정답: D

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

문제2
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. Assign everyone on the sales team to the same virtual warehouse.

B. Wrap the query in a User-Defined Function (UDF) to match syntax execution.

C. Leverage the CURRENT_DATE function for date calculations.

D. Assign everyone on the sales team to the same security role.

정답: C

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

문제3
An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
At 80% usage notify the account Administrators.
At 100% usage suspend the warehouse and notify the account Administrators.
At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

A. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do notify and suspend
on 120 percent do notify and suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

B. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

C. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

D. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

정답: D

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

문제4
A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

A. The table is not big enough to take advantage of the clustering key.

B. Sales across stores are not uniformly distributed.

C. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

D. The STORE_ID should be numeric.

정답: B

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

문제5
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE
default_role = DEVELOPER_ROLE;
The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

A. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

B. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

C. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

D. The new role can only take effect after USERADMIN has logged out.

정답: A

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

문제6
What are benefits of using Snowflake organizations? (Choose two.)

A. Administrators can change Snowflake account editions on-demand based on need.

B. Administrators can simplify data movement across all accounts within the organization.

C. User administration is simplified across all accounts within the organization.

D. Administrators have the ability to create accounts in any available cloud provider or region.

E. Administrators can monitor and understand usage across all accounts in the organization.

정답: D,E

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

문제7
Which tasks can be performed by the ORGADMIN role? (Choose three.)

A. View usage information for all accounts in the organization.

B. Create a reader account to share data with another organization.

C. View a list of all regions enabled for the organization.

D. Create secure views on application tables within the organization.

E. Create one or more accounts in the organization.

F. Perform zero-copy cloning on account data.

정답: A,C,E

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

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

자격증의 중요성:

ITDumpsKR 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기