Free Access Snowflake.ARA-C01.v2026-06-21.q128 Practice Test (Page 25)

Question 116

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

A.A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.

B.If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share.

C.If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.

D.If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share.

Question 117

What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

A.The use of a GET command

B.The use of a PUT command

C.The use of a ROLLBACK command

D.The use of a CALL command to a stored procedure which returns a table

E.Submitting multiple SQL statements in a single call

Question 118

Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?

A.create schema EDW.ACCOUNTING WITH MANAGED ACCESS;

B.create schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS - 7;

C.create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 1;

D.create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
DATA_RETENTION_TIME_IN_DAYS = 7;

Question 119

A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schem a. One of the requirements is to have online recovery of data on a rolling 7-day basis.
After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.
What would cause this to occur? (Choose two.)

A.The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

B.The staging tables are of the TRANSIENT type.

C.The staging schema has not been setup for MANAGED ACCESS.

D.The tables exceed the 1 TB limit for data recovery.

E.The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.

Question 120

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

A.The MERGE command

B.The UPSERT command

C.The CHANGES clause

D.A STREAM object

E.The CHANGE_DATA_CAPTURE command

Other Version: 2231Snowflake.ARA-C01.v2025-09-27.q148; 4241Snowflake.ARA-C01.v2025-02-14.q177; 1631Snowflake.ARA-C01.v2024-05-05.q106

Latest Upload: 129Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 135SAP.C_CR125_2601.v2026-08-17.q28; 179Salesforce.Field-Service-Consultant.v2026-08-17.q134; 150Oracle.1Z0-1170.v2026-08-16.q64; 156Oracle.1Z1-1170.v2026-08-16.q64; 193Juniper.JN0-336.v2026-08-13.q60; 327EMC.NCP-AII.v2026-08-13.q200; 205CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 162ISQI.CT-GenAI.v2026-08-11.q14

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File