Black Friday Countdown: 75% Off Exam Bundles! Use coupon code below before time runs out! - Ends in 0d 00h 00m 00s - Coupon code: 75vsure

ADA-C02 Exam Dumps - SnowPro Advanced: Administrator

Searching for workable clues to ace the Snowflake ADA-C02 Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s ADA-C02 PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

Go to page:
Question # 9

Which Snowflake objects can be managed through SCIM integration?

Choose two

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Full Access
Question # 10

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?

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.

Full Access
Question # 11

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.

An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?

Choose two

A.

OPERATE

B.

MODIFY

C.

MONITOR

D.

USAGE

E.

OWNERSHIP

Full Access
Question # 12

A large multinational company with numerous operating regions needs data to be shared bidirectionally among all offices: from the head office to regional offices and among regional offices themselves. The company holds a Snowflake account, with its European operations deployed in Microsoft Azure in a single region, while North American regional offices use AWS in a single region as their deployment cloud. This configuration is required to comply with Personal Identifiable Information (PII) regulations in certain European countries. The corporate head office is located in Europe.

How can the data be shared bidirectionally while MINIMIZING costs?

A.

Use data replication everywhere to reduce costs associated with same-region sharing.

B.

Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

C.

Move all the Snowflake accounts to a single region, and implement data sharing.

D.

Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

Full Access
Question # 13

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

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

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

Full Access
Question # 14

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

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

Full Access
Question # 15

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 # 16

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
Go to page: