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

문제1

What roles can be used to create network policies within Snowflake accounts? (Select THREE).

A. SECURITYADMIN

B. Any role with the global permission of CREATE NETWORK POLICY

C. ORGADMIN

D. SYSADMIN

E. ACCOUNTADMIN

F. Any role that owns the database where the network policy is created

정답: A,B,E

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

문제2

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? (Select THREE).

A. SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

B. SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

C. SELECT * FROM my_table AT (OFFSET => -60*30);

D. SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);

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);

정답: A,B,F

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

문제3

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

A. Create it as a permanent table with a retention time of 0 days.

B. Create it as a transient table with a retention time of 0 days.

C. Create it as an external table, which will not incur Time Travel costs.

D. Create it as a temporary table with a retention time of 0 days.

정답: B

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

문제4

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 회원만 볼 수 있음)

문제5

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

A. There should be another 2XL warehouse deployed to handle a portion of the load queries.

B. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

C. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

D. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

정답: C

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

문제6

A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT dat a. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).

A. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.

B. The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

C. The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

D. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

E. Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

정답: A,C

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

문제7

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 회원만 볼 수 있음)

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

우리와 연락하기

유용한 링크

최신 업데이트