Black Friday VIP Hour Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

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

Exam ADA-C02 Premium Access

View all detail and faqs for the ADA-C02 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

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.

Questions # 12:

Which Snowflake objects can be managed through SCIM integration?

Choose two

Options:

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Questions # 13:

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

Options:

A.

Reset a Snowflake user's password

B.

Manage system grants

C.

Create new users

D.

Create new roles

Questions # 14:

A Snowflake Administrator must configure Time Travel for a presentation area containing fact and dimension tables that receives substantial meaningless and erroneous IoT data. Time Travel is part of the company’s data-quality process, where the ingestion pipeline must revert to a known, high-quality data state if anomalies are found in the most recent load. Because of latencies in the data-acquisition process, data from the prior 30 days might need to be retrieved.

Options:

A.

ccording to best practices, how should these requirements be satisfied?

Choose two

B.

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

C.

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.

D.

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

E.

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

F.

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.

Questions # 15:

A development team has created a new schema for a new project. The developers hold the DEV_TEAM role, which was configured with these statements:

USE ROLE SECURITYADMIN;

C. REATE ROLE DEV_TEAM;

GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;

GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;

E. ach team member's access is configured with the following statements:

USE ROLE SECURITYADMIN;

C. REATE ROLE JDOE_PROFILE;

C. REATE USER JDOE LOGIN_NAME = ’JDOE’ DEFAULT_ROLE=’JDOE PROFILE’;

GRANT ROLE JDOE_PROFILE TO USER JDOE;

GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;

New tables created by any developer cannot be accessed by the team as a whole. How can an Administrator resolve this issue?

Options:

A.

Assign ownership privilege to DEV_TEAM on the newly-created schema.

B.

Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

C.

Set up future grants on the newly-created schemas.

D.

Set up the new schema as a managed-access schema.

Questions # 16:

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

Question # 16

What can the Snowflake Administrator do to optimize 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.

Questions # 17:

C. ompany A uses Snowflake to manage audio files containing call recordings. Company A hired Company B, which also uses Snowflake, to transcribe the audio files for additional analysis.

C. ompany A’s Administrator created a share. What object should be added to the share to give 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.

Questions # 18:

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?

Options:

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.

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions