Online Access Free Snowflake.ADA-C02.v2026-05-08.q24 Practice Test (Page 5)

ADA-C02 Exam Question 16

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

A.CURRENT ROLE

B.CURRENT ACCOUNT

C.CURRENT USER

D.CURRENT CLIENT

ADA-C02 Exam Question 17

Which tasks can be performed by the ORGADMIN role? (Choose three.)

A.Create one or more accounts in the organization.

B.View a list of all regions enabled for the organization.

C.Create secure views on application tables within the organization.

D.View usage information for all accounts in the organization.

E.Perform zero-copy cloning on account data.

F.Create a reader account to share data with another organization.

ADA-C02 Exam Question 18

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Choose three.)

A.SELECT * FROM my_table WITH TIME TRAVEL(OFFSET => -60*30);

B.SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);

C.SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);

D.SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

E.SELECT * FROM my_table AT(OFFSET => -60*30);

F.SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

ADA-C02 Exam Question 19

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

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

ADA-C02 Exam Question 20

Which type of listing in the Snowflake Marketplace can be added and queried immediately?

A.Monetized listing

B.Standard listing

C.Regional listing

D.Personalized listing

Latest Upload: 145Pegasystems.PEGACPDC25V1.v2026-07-17.q45; 231CompTIA.N10-009.v2026-07-17.q230; 162EMC.D-PDM-DY-23.v2026-07-17.q66; 162Salesforce.ADM-201.v2026-07-17.q63; 399PMI.CAPM.v2026-07-17.q643; 165Cisco.300-215.v2026-07-17.q60; 432CollegeAdmission.PMHNP.v2026-07-17.q640; 216Microsoft.MB-240.v2026-07-17.q174; 139SAP.C_CE325_2601.v2026-07-17.q37; 290Microsoft.AZ-900.v2026-07-16.q224

ADA-C02 Exam Question 16

ADA-C02 Exam Question 17

ADA-C02 Exam Question 18

ADA-C02 Exam Question 19

ADA-C02 Exam Question 20

Download PDF File