Black Friday Flash Sale - Everything Must Go at 75% Off - Ends in 0d 00h 00m 00s - Coupon code: w75best

Snowflake ADA-C02 Dumps

Page: 1 / 6
Total 60 questions

SnowPro Advanced: Administrator Questions and Answers

Question 1

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?

Options:

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.

Question 2

An Administrator has been asked to support the company’s application team, which needs to build a loyalty program for its customers. The customer table contains Personally Identifiable Information (PII), and the application team has the DEVELOPER role.

C. REATE TABLE customer_data (

customer_first_name string,

customer_last_name string,

customer_address string,

customer_email string,

... some other columns,

);

The application team needs access to the customer data, but the email field must be obfuscated. How can the Administrator safeguard the sensitive information while retaining the data’s usability?

Options:

A.

Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.

B.

Create a separate table for all the non-PII columns and grant the role DEVELOPER access to the new table.

C.

Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

D.

Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

Question 3

Which roles may be used to create network policies in Snowflake accounts?

Choose three

Options:

A.

SYSADMIN

B.

SECURITYADMIN

C.

ACCOUNTADMIN

D.

ORGADMIN

E.

Any role with the global permission of CREATE NETWORK POLICY

F.

Any rote that owns the database where the network policy is created

Question 4

What requirements apply when creating a new account in a Snowflake organization?

Choose two

Options:

A.

The account requires at least one ORGADMIN rote within one of the organization's accounts.

B.

The account name is immutable and cannot be changed.

C.

The account name must be specified when the account is created.

D.

The account name must be unique among all Snowflake customers.

E.

The account name must be unique within the organization.

Question 5

Which Snowflake objects can be managed through SCIM integration?

Choose two

Options:

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Question 6

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 7

An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:

B. etween 50 and 100 concurrent users will run reports.

C. osts must be minimized according to the number of users active at a particular time.

The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?

Options:

A.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

B.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = FALSE;

C.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

AUTO_SUSPEND = 60

AUTO_RESUME = TRUE;

D.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

Question 8

In general, monthly database-replication billing is proportional to which variables?

Choose two

Options:

A.

The frequency of changes to the primary database as a result of data loading or DML operations

B.

The amount of table data in the primary database that changes as a result of data loading or DML operations

C.

The frequency of the secondary database refreshes from the primary database

D.

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

E.

The number and size of warehouses defined in the primary account

Question 9

What is needed for credential-free stages to restrict data exfiltration after a storage integration and its associated stages have been created?

Options:

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

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

ALTER ACCOUNT my_account SET

REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;

ALTER ACCOUNT my_account SET

PREVENT_UNLOAD_TO_INLINE_URL = false;

D.

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;

Question 10

A Snowflake organization, MYORG, contains two Snowflake accounts:

as

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

Options:

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.

Question 11

A Snowflake Administrator uses a multi-cluster virtual warehouse in the Snowflake Business-Critical edition. The minimum cluster count is set to 2, and the maximum cluster count is set to 10. This configuration performs well for the normal workload, which seldom exceeds 5 running clusters. However, once each month, several complex long-running queries increase queue time and cause the warehouse to reach its maximum of 10 clusters.

Which solutions will resolve the issues that occur once a month?

Choose 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.

Question 12

A Snowflake Administrator needs to retain all virtual warehouse configurations for auditing and backup. A table already exists with this schema:

as

Which commands should be run to persist the warehouse data at execution time in JSON format in the VWH_META table?

Options:

A.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(),

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));

B.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(), *

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

C.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(),

OBJECT_CONSTRUCT(*)

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

D.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(), *

FROM TABLE(RESULT_SCAN(SELECT

LAST_QUERY_ID(-1)));

Question 13

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 14

In which scenario does using an external table simplify a data pipeline?

Options:

A.

When accessing a Snowflake table from a relational database

B.

When accessing a Snowflake table from an external database within the same region

C.

When continuously writing data from a Snowflake table to external storage

D.

When accessing a Snowflake table that references data files located in cloud storage

Question 15

A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.

B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?

Options:

A.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

B.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

C.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

D.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

Question 16

If a query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

Options:

A.

No, because joins are not supported by materialized views.

B.

No, because the optimizer might decide against it.

C.

No, because the materialized view may not be up-to-date.

D.

Yes, because materialized views are always faster.

Question 17

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

Options:

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');

Question 18

An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.

Which SELECT command generates 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);

Page: 1 / 6
Total 60 questions