最新的SnowPro Advanced: Administrator認證 ADA-C01考試題庫

問題1

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

A. The amount of table data in the primary database that changes as a result of data loading or DML operations

B. The frequency of the secondary database refreshes from the primary database

C. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

D. The frequency of changes to the primary database as a result of data loading or DML operations

E. The number and size of warehouses defined in the primary account

正確答案: A,D

說明：（僅 VCESoft 成員可見）

問題2

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

A. Include masking rules as part of data ingestion and transformation pipelines.

B. Use zero-copy cloning to replicate the database schema and provide access as needed.

C. Implement row access policies and Dynamic Data Masking policies.

D. Use a third-party tool to share the data.

E. Implement views on top of base tables that exclude or mask sensitive data.

正確答案: C,E

問題3

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD. WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number) ;
Which role(s) can alter or drop table XYZ?

A. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

B. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

C. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題4

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 data. 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. Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

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. The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.

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

正確答案: C,D

說明：（僅 VCESoft 成員可見）

問題5

A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

A. The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

B. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

C. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

D. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題6

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

A. Any role with USAGE privilege on the Data Exchange

B. Any role that the listing provider has designated as authorized

C. Only the ACCOUNTADMIN role, and no other roles

D. Any role with IMPORT SHARE and CREATE DATABASE privileges

正確答案: A

說明：（僅 VCESoft 成員可見）

問題7

When does auto-suspend occur for a multi-cluster virtual warehouse?

A. When there has been no activity on any cluster for the specified period of time.

B. After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

C. When the minimum number of clusters is running and there is no activity for the specified period of time.

D. Auto-suspend does not apply for multi-cluster warehouses.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題8

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

A. Queries executed within a given transaction see that transaction's uncommitted changes.

B. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

C. Transaction locking in Snowflake is enforced exclusively at the row and table levels.

D. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

正確答案: D

說明：（僅 VCESoft 成員可見）

最新的Snowflake SnowPro Advanced Administrator - ADA-C01免費考試真題

最新更新

站內鏈接

聯系我們