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

出題：1

What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

A. IdP encryption key

B. SAML response format

C. Authentication certificate

D. IdP account details

E. URL endpoint for SAML requests

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

解説: (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 team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = 'JDOE' DEFAULT ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

A. Set up future grants on the newly-created schemas.

B. Assign ownership privilege to DEV_TEAM on the newly-created schema.

C. Set up the new schema as a managed-access schema.

D. Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

正解：A 解答を投票する

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

出題：4

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

A. To save costs by running the warehouse as little as possible

B. To keep the query result cache warm for good performance on repeated queries

C. To save costs on warehouse shutdowns and startups for different queries

D. To keep the data cache warm to support good performance of similar queries

正解：D 解答を投票する

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

出題：5

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose 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

What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)

A. Contact Snowflake Support to retrieve Fail-safe data.

B. SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');

C. CREATE TABLE prd_table_bkp as SELECT * from table(result_scan('problematic_query_id'));

D. ALTER TABLE prd_table SWAP WITH prd_table_bkp;

E. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');

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

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

出題：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. Auto-suspend does not apply for multi-cluster warehouses.

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

正解：D 解答を投票する

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

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