Black Friday Grand offer - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code = drift75

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

Practice at least 50% of the questions to maximize your chances of passing.
Exam ADA-C02 Premium Access

View all detail and faqs for the ADA-C02 exam


0 Students Passed

0% Average Score

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

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 # 2:

F. or Snowflake network policies, what happens when both account_level and user_level network policies are defined?

Options:

A.

The account_level policy will override the user_level policy.

B.

The user_level policy will override the account_level policy.

C.

The user_level network policies will not be supported.

D.

A network policy error will be generated with no definitions provided.

Questions # 3:

The following commands have been run:

Grant usage on database PROD to role PROD_ANALYST;

Grant usage on database PROD to role PROD_SUPERVISOR;

Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;

Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;

Grant role PROD_ANALYST to user A;

Grant role PROD_SUPERVISOR to user B;

What authority does each user have on the WORKING schema?

Options:

A.

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

B.

Tables created by either user A or user B will be visible to both users.

C.

All existing tables in schema PROD.WORKING will be visible to both users.

D.

Both user A and user B can create tables in the PROD.WORKING schema.

Questions # 4:

A user with the appropriate role runs the following commands to configure and activate network policies:

Question # 4

Options:

A.

fterward, user1 tries to sign in to Snowflake from IP address 3.3.3.10. Will the login succeed?

B.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

C.

No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

D.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

E.

No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

Questions # 5:

Which SCIM integration types does Snowflake support?

Choose 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

Questions # 6:

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

Questions # 7:

Which Snowflake capabilities are typically used for rollback scenarios?

Choose two

Options:

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.

Questions # 8:

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.

Questions # 9:

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

Options:

A.

OPERATE

B.

MODIFY

C.

MONITOR

D.

USAGE

E.

OWNERSHIP

Questions # 10:

Which benefits result from creating and maintaining resource monitors in Snowflake?

Choose three

Options:

A.

The cost of running a resource monitor is only 10% of a credit, per day of operation.

B.

Multiple resource monitors can be applied to a single virtual warehouse.

C.

Resource monitors add no additional load to virtual warehouse compute.

D.

Multiple triggers can be configured across various virtual warehouse thresholds.

E.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

F.

Resource monitors can be applied to more than one virtual warehouse.

Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.