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

문제1

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 user_level network policies will not be supported.

D. The account_level policy will override the user_level policy.

정답: B

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

문제2

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

B. OWNERSHIP

C. MONITOR

D. MODIFY

E. OPERATE

정답: A,C

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

문제3

What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

A. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION FOR STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

B. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

C. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

D. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

정답: A

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

문제4

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?

A. Sequences, storage integrations, views, secure views, and materialized views

B. Sequences, views, secure views, and materialized views

C. Sequences, views, and secure views

D. There are no object references that need to be re-pointed

정답: A

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

문제5

A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?

A. The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.

B. The IdP service account requires a new RSA key pair to be generated every six months.

C. The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.

D. The Administrator must issue a POST RENEW call to the REST API at least once every six months.

정답: C

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

문제6

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

A. GRANT ROLE ORGADMIN TO USER <username>;

B. SHOW ORGANIZATION ACCOUNTS;

C. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (
'ACCOUNT LOCATOR',
'ENABLE ACCOUNT DATABASE_REPLICATION',
'true'
);

D. SHOW USERS;

E. SHOW REGIONS;

정답: B,C

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

문제7

The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR;
Grant role PROD ANALYST to user A;
Grant role PROD SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

A. Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

B. All existing tables in schema PROD. WORKING will be visible to both users.

C. Both user A and user B can create tables in the PROD. WORKING schema.

D. Tables created by either user A or user B will be visible to both users.

정답: C

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

우리와 연락하기

유용한 링크

최신 업데이트