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

A. grant role okta_provisioner to role ACCOUNTADMIN;
create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update these steps every 12 months.

B. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 12 months.

C. create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update this step every 6 months.

D. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 6 months.

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

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

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

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

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 = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

C. 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;

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 = false;

A. Database: Usage
Schema: Usage
Table: Select, Create Stream

B. Database: Usage
Schema: Usage, Create Stream
Table: Select

C. Database: Usage
Schema: Usage
Table: Select

D. Database: Usage, Create Stream
Schema: Usage
Table: Select

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

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

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 INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

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.

A. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

B. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

C. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

D. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.