Last Chance Black Friday Deal: Take 75% Off! Use coupon code below to secure your exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: my75ex

Home > Snowflake > SnowPro Advanced: Administrator > ADA-C02

ADA-C02 SnowPro Advanced: Administrator Question and Answers

Question # 4

Which Snowflake capabilities are typically used for rollback scenarios?

Choose two

A.

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

B.

CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT = > ‘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.

Contact Snowflake Support to retrieve Fail-safe data.

Full Access
Question # 5

What are the advantages of using Snowflake organizations?

Choose two

A.

Administrators can change Snowflake account editions on-demand based on need.

B.

Administrators can monitor and understand usage across all accounts in the organization.

C.

Administrators can simplify data movement across all accounts within the organization.

D.

User administration is simplified across all accounts within the organization.

E.

Administrators have the ability to create accounts in any available cloud provider or region.

Full Access
Question # 6

MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries allow the user to view the historical data that was in the table before this query ran?

Choose three

A.

SELECT * FROM my_table WITH TIME_TRAVEL(OFFSET = > -60*30);

B.

SELECT * FROM my_table AT(TIMESTAMP = > '2021-01-01 07:00:00'::timestamp);

C.

SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);

D.

SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

E.

SELECT * FROM my_table AT(OFFSET = > -60*30);

F.

SELECT * FROM my_table BEFORE(STATEMENT = > '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

Full Access
Question # 7

Which of the following are characteristics of Dynamic Data Masking?

Choose two

A.

A masking policy that is currently set on a table can be dropped.

B.

A single masking policy can be applied to columns in different tables.

C.

A masking policy can be applied to the VALUE column of an external table.

D.

The role that creates the masking policy will always see unmasked data in query results.

E.

A single masking policy can be applied to columns with different data types.

Full Access
Question # 8

A Snowflake organization, MYORG, contains two Snowflake accounts:

ACCOUNT1 has a database named PROD_DB and has the ORGADMIN role enabled. Management wants PROD_DB replicated to ACCOUNT2.

A.

re any configuration steps required in ACCOUNT1 before database replication can be configured and started in ACCOUNT2?

B.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT1',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT2',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB

ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2;

C.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT1',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB

ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2

IGNORE EDITION CHECK;

D.

No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

E.

It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

Full Access
Question # 9

Which session parameter can be used to test the integrity of secure views based on the account that accesses the view?

A.

MIMIC_CONSUMER_ACCOUNT

B.

TEST_ACCOUNT_ID

C.

PRODUCER_TEST_ACCT

D.

SIMULATED_DATA_SHARING_CONSUMER

Full Access
Question # 10

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

A.

Any role with GRANT USAGE on SECURITY INTEGRATION

B.

ACCOUNTADMIN and SYSADMIN

C.

ACCOUNTADMIN and SECURITYADMIN

D.

ACCOUNTADMIN only

Full Access
Question # 11

Which are characteristics of data replication in Snowflake?

Choose three

A.

The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

B.

Users must be granted REPLICATIONADMIN privileges in order to enable replication.

C.

To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

D.

Replication can only occur within the same cloud provider.

E.

Databases created from shares can be replicated.

F.

Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

Full Access
Question # 12

Which command can temporarily disable multi-factor authentication (MFA) for the Snowflake username user1 for 24 hours?

A.

alter user user1 set MINS_TO_BYPASS_MFA=1440;

B.

alter user user1 set DISABLE_MFA=1440;

C.

alter user user1 set TEMPORARY_MFA_BYPASS=1440;

D.

alter user user1 set HOURS_TO_BYPASS_MFA=24;

Full Access
Question # 13

Which type of Snowflake Marketplace listing can be added and queried right away?

A.

Monetized listing

B.

Standard listing

C.

Regional listing

D.

Personalized listing

Full Access
Question # 14

A sales team at an organization runs the following Snowflake query several times each day:

What can the Snowflake Administrator do to optimize use of persisted query results whenever possible?

A.

Wrap the query in a User-Defined Function (UDF) to match syntax execution.

B.

Assign everyone on the sales team to the same virtual warehouse.

C.

Assign everyone on the sales team to the same security role.

D.

Leverage the CURRENT_DATE function for date calculations.

Full Access
Question # 15

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?

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.

Full Access
Question # 16

C. reating a stream on a standard table requires the CREATE STREAM privilege on the target schema and SELECT on the source table. The role also needs USAGE on the parent database and schema to access objects in that location.

An Administrator loads data into a staging table each day. After it is loaded, users from several different departments transform the data and load it into different production tables.

How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

A.

Create it as an external table, which will not incur Time Travel costs.

B.

Create it as a transient table with a retention time of 0 days.

C.

Create it as a temporary table with a retention time of 0 days.

D.

Create it as a permanent table with a retention time of 0 days.

Full Access
Question # 17

Which responsibility belongs to the SECURITYADMIN role but is not granted to the USERADMIN role?

A.

Reset a Snowflake user's password

B.

Manage system grants

C.

Create new users

D.

Create new roles

Full Access
Question # 18

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

A.

1 day

B.

14 days

C.

30 days

D.

90 days

Full Access