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

Download Full Version ADA-C02 Snowflake Exam

Page: 4 / 5
Total 60 questions

SnowPro Advanced: Administrator Questions and Answers

Question 13

When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?

Options:

A.

CURRENT_ROLE

B.

CURRENT_ACCOUNT

C.

CURRENT_USER

D.

CURRENT_CLIENT

Question 14

A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.

Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?

Options:

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.

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

C.

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

D.

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

Question 15

Which commands can a user with the ORGADMIN role, but without the ACCOUNTADMIN role, perform?

Choose two

Options:

A.

SHOW REGIONS;

B.

SHOW USERS;

C.

SHOW ORGANIZATION ACCOUNTS;

D.

GRANT ROLE ORGADMIN TO USER < username > ;

E.

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'ACCOUNT_LOCATOR',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'true'

);

Question 16

What is the default data-retention period for transient databases, schemas, and tables in Snowflake Enterprise Edition and higher?

Options:

A.

1 day

B.

14 days

C.

30 days

D.

90 days

Page: 4 / 5
Total 60 questions