ADA-C01試験無料問題集（80題）「Snowflake SnowPro Advanced Administrator 認定」

出題：1

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 grant the USAGE privilege on each database referenced by the secure view.

B. 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

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

D. 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.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

A. A network policy error will be generated with no definitions provided.

B. The user_level policy will override the account_level policy.

C. The account_level policy will override the user_level policy.

D. The user_level network policies will not be supported.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company's Time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

A. Set the data retention policy on the schemas in the secondary database to 60 days.

B. Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

C. Set the data retention policy on the secondary database to 60 days.

D. Set the data retention policy on the primary database to 60 days.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

A. The SECURITYADMIN role

B. The role executing the command

C. The SYSADMIN role

D. The role above the dropped role in the RBAC hierarchy

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

A. Adding region availability to the listing

B. Dropping a column from a table

C. Deleting data from a table

D. Renaming a table

E. Unpublishing the data listing

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：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 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. 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.

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

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.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).

A. MODIFY

B. OWNERSHIP

C. USAGE

D. OPERATE

E. MONITOR

正解：C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

A. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
User ABC is the only user with an ACCOUNTADMIN role.

B. CREATE NETWORK POLICY ADMIN POLICY
ALLOWED_IP_LIST = ('192.168.1.100');
ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

C. CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

D. CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED IP LIST = ('192.168.1.100')
BLOCKED_IP_LIST = ('0.0.0.0/0');
ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

ADA-C01試験無料問題集「Snowflake SnowPro Advanced Administrator 認定」