Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Pass the Snowflake SnowPro Advanced: Administrator ADA-C02 Questions and answers with CertsForce

Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
Questions # 1:

A company has enabled replication between accounts and is ready to replicate data across Regions within the same cloud service provider.

The primary database object is: PROD_AWS_EAST. Location: AWS_EAST.

The secondary database object is: PROD_AWS_WEST. Location: AWS_WEST.

What command and account location are required to refresh the data?

Options:

A.

Location : AWS_WEST -Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;


B.

Location : AWS_WEST -Command : ALTER DATABASE PROD_AWS_WEST REFRESH;


C.

Location : AWS_EAST -Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;


D.

Location : AWS_EAST -Command : ALTER DATABASE PROD_AWS_WEST REFRESH;


Expert Solution
Questions # 2:

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;


Expert Solution
Questions # 3:

What are the minimum grants needed on the database, schema, and table to correctly create and manage a stream?

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


Expert Solution
Questions # 4:

An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.

How can this be achieved?

Options:

A.

Apply RBAC directly onto the partner's shared secure views.


B.

Individually grant imported privileges onto the schema in the share.


C.

Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.


D.

Create views over the incoming shared database and apply the desired RBAC onto these views.


Expert Solution
Questions # 5:

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


Expert Solution
Questions # 6:

A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.

How can the Administrator lower costs while minimizing the overall time required to load 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.


Expert Solution
Questions # 7:

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.


Expert Solution
Questions # 8:

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


Expert Solution
Questions # 9:

Under what condition does auto-suspend take place for a multi-cluster virtual warehouse?

Options:

A.

When there has been no activity on any cluster for the specified period of time.


B.

After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.


C.

When the minimum number of clusters is running and there is no activity for the specified period of time.


D.

Auto-suspend does not apply for multi-cluster warehouses.


Expert Solution
Questions # 10:

A Snowflake organization, MYORG, contains two Snowflake accounts:

Question # 10

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.


Expert Solution
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions