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
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?
Which Snowflake objects can be managed through SCIM integration?
Choose two
Which responsibility belongs to the SECURITYADMIN role but is not granted to the USERADMIN role?
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.
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?
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?
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?
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?