Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Legit ADA-C02 Exam Download

Page: 3 / 5
Total 60 questions

SnowPro Advanced: Administrator Questions and Answers

Question 9

Which information must be obtained from the Identity Provider (IdP) to enable federated authentication in Snowflake?

Choose two

Options:

A.

IdP account details

B.

URL endpoint for SAML requests

C.

SAML response format

D.

Authentication certificate

E.

IdP encryption key

Question 10

A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be fulfilled?

Options:

A.

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

B.

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

C.

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

D.

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

Question 11

Which role or roles should be used to correctly create the object needed to configure an OAuth 2.0 integration?

Options:

A.

Any role with GRANT USAGE on SECURITY INTEGRATION

B.

ACCOUNTADMIN and SYSADMIN

C.

ACCOUNTADMIN and SECURITYADMIN

D.

ACCOUNTADMIN only

Question 12

Which steps are needed to configure OKTAAPI token integration in Snowflake?

Options:

A.

See original SQL exhibit above.

grant role okta_provisioner to role ACCOUNTADMIN;2. create or replace security integration okta_provisioningtype = scimscim_client = 'okta'run_as_role = 'OKTA_PROVISIONER';3. Update these steps every 12 months.

B.

See original SQL exhibit above.

use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 12 months.

C.

See original SQL exhibit above.

create or replace security integration okta_provisioningtype = scimscim client = 'okta'run_as_role = 'OKTA_PROVISIONER';2. Update this step every 6 months.

D.

See original SQL exhibit above.

use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 6 months.

Page: 3 / 5
Total 60 questions