최신 ADA-C01 무료덤프 - Snowflake SnowPro Advanced Administrator

문제1

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).

A. Increase the multi-cluster maximum to 20 or more clusters.

B. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

C. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

D. Increase the minimum number of clusters started in the multi-cluster configuration to 5.

E. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

정답: B,E

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

문제2

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

A. Use the following SQL command:
create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

B. Transient tables will persist until explicitly dropped and contribute to overall storage costs.

C. Use the following SQL commands:
create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

D. Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

E. Use the following SQL command:
create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

정답: A,B

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

문제3

A Snowflake Administrator is investigating why a query is not re-using the persisted result cache.
The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view:

Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?

A. The queries are executed with two different roles.

B. The queries are executed with two different virtual warehouses.

C. The second query includes a CURRENT_TIMESTAMP () function.

D. The second query includes a CURRENT_DATE () function.

정답: C

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

문제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 sample system (20);

C. select * from LINEITEM tablesample block (20 rows);

D. select * from LINEITEM tablesample system (20) seed (1);

정답: B

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

문제5

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:
USE ROLE SECURITYADMIN;
CREATE ROLE ROLE_MANAGED_ACCESS;
GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS;
GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS;
USE ROLE ROLE_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS;
USE ROLE SECURITYADMIN;
GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

A. USE ROLE ROLE MANAGED_ACCESS;
DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS;
Then recreate all needed objects.

B. ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

C. REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM ROLE_MANAGED_ACCESS; ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

D. USE ROLE ROLE_MANAGED_ACCESS;
DROP SCHEMA WORK. SCHEMA MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;
Then recreate all needed objects.

정답: B

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

문제6

What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

A. Multiple resource monitors can be applied to a single virtual warehouse.

B. Resource monitors add no additional load to virtual warehouse compute.

C. Multiple triggers can be configured across various virtual warehouse thresholds.

D. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

E. The cost of running a resource monitor is only 10% of a credit, per day of operation.

F. Resource monitors can be applied to more than one virtual warehouse.

정답: B,C,F

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

문제7

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

A. No, because joins are not supported by materialized views.

B. No, because the optimizer might decide against it.

C. Yes, because materialized views are always faster.

D. No, because the materialized view may not be up-to-date.

정답: B

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

문제8

Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1:

This statement is executed:
USE ROLE ACCOUNTADMIN;
DROP ROLE A;
What will occur?

A. The table object DB1. S1. T1 will be dropped.

B. The SELECT privileges for roles B and C will remain.

C. The SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role ACCOUNTADMIN.

D. The OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN role.

정답: B

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

최신 ADA-C01 무료덤프 - Snowflake SnowPro Advanced Administrator

우리와 연락하기

유용한 링크

최신 업데이트