Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

SnowPro Advanced: Administrator Certification Exam Question and Answers

SnowPro Advanced: Administrator Certification Exam

Last Update Apr 28, 2024
Total Questions : 72

We are offering FREE ADA-C01 Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare ADA-C01 free exam questions and then go for complete pool of SnowPro Advanced: Administrator Certification Exam test questions that will help you more.

ADA-C01 pdf

ADA-C01 PDF

$35  $99.99
 Add to Cart
ADA-C01 Engine

ADA-C01 Testing Engine

$42  $119.99
 Add to Cart
ADA-C01 PDF + Engine

ADA-C01 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous

loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any

anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.

According to best practices, how should these requirements be met? (Select TWO).

Options:

A.  

Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

B.  

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.

C.  

The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

D.  

Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

E.  

The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

Discussion 0
Questions 2

What SCIM integration types are supported in Snowflake? (Select THREE).

Options:

A.  

Amazon Web Services (AWS)

B.  

Google Cloud Platform (GCP)

C.  

Okta

D.  

Custom

E.  

Azure Active Directory (Azure AD)

F.  

Duo Security Provisioning Connector

Discussion 0
Questions 3

A Snowflake Administrator is investigating why a query is not re-using the persisted result cache.

The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view:

Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?

  • The second query includes a CURRENT_TIMESTAMP () function.

  • The second query includes a CURRENT_DATE () function.

  • The queries are executed with two different virtual warehouses.

Options:

A.  

The queries are executed with two different roles.

Discussion 0
Questions 4

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

Options:

A.  

create or replace masking policy maskstring as (val string) returns string ->

case

when is_role_in_session ('MASKED_VIEW_ROLE') then ' **

else val

end;

*,

B.  

create or replace masking policy maskString as (val string) returns string ->

case

when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '*

else val

end;

** '

C.  

create or replace masking policy maskstring as (val string) returns string ->

case

when invoker_role() in ('MASKED_VIEW_ROLE') then

else val

end;

' **

D.  

create or replace masking policy maskString as (val string) returns string ->

case

when current_role() in ('MASKED_VIEW_ROLE') then ' ********* '

else val

end;

Discussion 0
Questions 5

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the

maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the

Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.

Which solutions will address the issues happening once a month? (Select TWO).

Options:

A.  

Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

B.  

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

C.  

Increase the multi-cluster maximum to 20 or more clusters.

D.  

Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

E.  

Increase the minimum number of clusters started in the multi-cluster configuration to 5.

Discussion 0
Questions 6

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

Options:

A.  

CREATE NETWORK POLICY ADMIN_POLICY

ALLOWED_IP_LIST = ('192.168.1.100');

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

User ABC is the only user with an ACCOUNTADMIN role.

B.  

CREATE NETWORK POLICY ADMIN POLICY

ALLOWED_IP_LIST = ('192.168.1.100');

ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

C.  

CREATE NETWORK POLICY ADMIN_POLICY

ALLOWED IP LIST = ('192.168.1.100')

BLOCKED_IP_LIST = ('0.0.0.0/0');

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

D.  

CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY

ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

Discussion 0
Questions 7

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

Options:

A.  

SYSADMIN

B.  

SECURITYADMIN

C.  

ACCOUNTADMIN

D.  

IMPORT SHARE and CREATE DATABASE

E.  

IMPORT PRIVILEGES and SHARED DATABASE

Discussion 0
Questions 8

What access control policy will be put into place when future grants are assigned to both database and schema objects?

Options:

A.  

Database privileges will take precedence over schema privileges.

B.  

Schema privileges will take precedence over database privileges.

C.  

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

D.  

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Discussion 0
Questions 9

A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.

Which step should the Administrator take to allow the user to log in to the system, without revoking their 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.

Discussion 0
Questions 10

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration

workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single

warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.

How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

Options:

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.

Discussion 0
Questions 11

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.

What select command will generate a sample of 20% of the table?

Options:

A.  

select * from LINEITEM sample bernoulli (20);

B.  

select * from LINEITEM sample system (20);

C.  

select * from LINEITEM tablesample block (20 rows);

D.  

select * from LINEITEM tablesample system (20) seed (1);

Discussion 0
Questions 12

A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.

Management wants to have the PROD_DB database replicated to ACCOUNT2.

Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

Options:

A.  

USE ROLE ORGADMIN;

SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');

SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT2', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;

B.  

USE ROLE ORGADMIN;

SELECT SYSTEMSGLOBAL 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;

C.  

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

D.  

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

Discussion 0
Questions 13

.

Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further

analysis.

Company A's Administrator created a share.

What object should be added to the share to allow Company B access to the files?

Options:

A.  

A secure view with a column for file URLs.

B.  

A secure view with a column for pre-signed URLs.

C.  

A secure view with a column for METADATA$FILENAME.

D.  

A secure view with a column for the stage name and a column for the file path.

Discussion 0
Questions 14

The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts,

what roles in Account 123 are allowed to request and get data?

Options:

A.  

Only the ACCOUNTADMIN role, and no other roles

B.  

Any role with USAGE privilege on the Data Exchange

C.  

Any role with IMPORT SHARE and CREATE DATABASE privileges

D.  

Any role that the listing provider has designated as authorized

Discussion 0
Questions 15

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to

make a transient copy of this table and wants the transient table to have all the same permissions as the original table.

How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the

requirements? (Select TWO).

Options:

A.  

Use the following SQL command:

create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

B.  

Use the following SQL command:

create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

C.  

Use the following SQL commands:

create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants;

insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

D.  

Transient tables will persist until explicitly dropped and contribute to overall storage costs.

E.  

Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

Discussion 0
Questions 16

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

Options:

A.  

The SYSADMIN role

B.  

The role above the dropped role in the RBAC hierarchy

C.  

The role executing the command

D.  

The SECURITYADMIN role

Discussion 0
Questions 17

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Questions 18

A data provider wants to share data from multiple databases with a data consumer account.

How can this be accomplished?

Options:

A.  

The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

B.  

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

C.  

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

D.  

The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

Discussion 0
Questions 19

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

Options:

A.  

Database: Usage

Schema: Usage

Table: Select, Create Stream

B.  

Database: Usage

Schema: Usage

Table: Select

C.  

Database: Usage, Create Stream

Schema: Usage

Table: Select

D.  

Database: Usage

Schema: Usage, Create Stream

Table: Select

Discussion 0
Questions 20

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that

will perform the following tasks:

1. At 80% usage notify the account Administrators.

2. At 100% usage suspend the warehouse and notify the account Administrators.

3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.

Which SQL command will meet these requirements?

Options:

A.  

create or replace resource monitor RM1 with credit_quota=3000

start_timestamp = '2022-01-01 00:00 CET'

triggers on 80 percent do notify

on 100 percent do suspend

on 120 percent do suspend_immediate;

alter warehouse WH1 set resource_monitor = RM1;

B.  

create or replace resource monitor RM1 with credit_quota=3000

frequency = yearly

start_timestamp = '2022-01-01 00:00 CET'

triggers on 80 percent do notify

on 100 percent do suspend

on 120 percent do suspend_immediate;

alter warehouse WH1 set resource monitor = RM1;

C.  

create or replace resource monitor RM1 with credit_quota=3000

start_timestamp = '2022-01-01 00:00 CET'

triggers on 80 percent do notify

on 100 percent do notify and suspend

on 120 percent do notify and suspend_immediate;

alter warehouse WH1 set resource monitor = RM1;

D.  

create or replace resource monitor RM1 with credit_quota=3000

frequency = yearly

triggers on 80 percent do notify

on 100 percent do suspend

on 120 percent do suspend_immediate;

alter warehouse WH1 set resource_monitor = RM1;

Discussion 0
Questions 21

An organization's sales team leverages this Snowflake query a few times a day:

SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO

FROM CUSTOMERS

WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7);

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

Options:

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.

Discussion 0