Free Access to Snowflake.ARA-C01.v2026-01-01.q152 with Valid Practice Test (Page 27)

Question 126

Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Select TWO).

A.A white background with black text Description automatically generated
B.A white background with black text Description automatically generated
C.A close-up of a computer code Description automatically generated
D.A computer code with black text Description automatically generated
E.A close-up of a computer code Description automatically generated

Correct Answer: B,E

* The architecture in the image shows a Snowflake data platform with two databases, DB1 and DB2, and two schemas, SH1 and SH2. DB1 contains a table TBL1 and a stage STAGE1. DB2 contains a table TBL2. The image also shows a snippet of code written in SQL language that copies data from STAGE1 to TBL2 using a file format FF PIPE 1.
* To copy data from DB1 to TBL2, there are two possible options among the choices given:
* Option B: Use a named external stage that references STAGE1. This option requires creating an external stage object in DB2.SH2 that points to the same location as STAGE1 in DB1.SH1. The external stage can be created using the CREATE STAGE command with the URL parameter specifying the location of STAGE11. For example:
SQLAI-generated code. Review and use carefully. More info on FAQ.
use database DB2;
use schema SH2;
create stage EXT_STAGE1
url = @DB1.SH1.STAGE1;
* Then, the data can be copied from the external stage to TBL2 using the COPY INTO command with the FROM parameter specifying the external stage name and the FILE FORMAT parameter specifying the file format name2. For example:
SQLAI-generated code. Review and use carefully. More info on FAQ.
copy into TBL2
from @EXT_STAGE1
file format = (format name = DB1.SH1.FF PIPE 1);
* Option E: Use a cross-database query to select data from TBL1 and insert into TBL2. This option requires using the INSERT INTO command with the SELECT clause to query data from TBL1 in DB1.SH1 and insert it into TBL2 in DB2.SH2. The query must use the fully-qualified names of the tables, including the database and schema names3. For example:
SQLAI-generated code. Review and use carefully. More info on FAQ.
use database DB2;
use schema SH2;
insert into TBL2
select * from DB1.SH1.TBL1;
* The other options are not valid because:
* Option A: It uses an invalid syntax for the COPY INTO command. The FROM parameter cannot specify a table name, only a stage name or a file location2.
* Option C: It uses an invalid syntax for the COPY INTO command. The FILE FORMAT parameter cannot specify a stage name, only a file format name or options2.
* Option D: It uses an invalid syntax for the CREATE STAGE command. The URL parameter cannot specify a table name, only a file location1.
References:
* 1: CREATE STAGE | Snowflake Documentation
* 2: COPY INTO table | Snowflake Documentation
* 3: Cross-database Queries | Snowflake Documentation

Question 127

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

A.At the root level (HSM)
B.At the account level (AMK)
C.At the table level (TMK)
D.At the micro-partition level

Question 128

You ran the below query. I have a warehouse with auto suspend set at 5 seconds
SELECT * FROM INVENTORY;
The query profile looks like as below. Please see below 'Percentage scanned from cache' is 0%

You ran the query again before 5 seconds has elapsed and the query profile looks as below. Look at the 'Percentage scanned for cache', it is 75%

You ran the query again after 5 seconds. The query profile looks as below. Look at the 'Percentage scanned from cache', it is zero again.

Why is this happening?

A.The second run of the query used data cache to retrieve part of the result since it ran before the warehouse was suspended
B.The third run of the query used query result cache
C.The second run of the query used query result cache

Question 129

How do you refresh a materialized view?

A.ALTER VIEW <MV_NAME> REFRESH
B.REFRESH MATERIALIZED VIEW <MV_NAME>
C.Materialized views are automatically refreshed by snowflake and does not require manual intervention

Question 130

An Architect is using SnowCD to investigate a connectivity issue.
Which system function will provide a list of endpoints that the network must be able to access to use a specific Snowflake account, leveraging private connectivity?

A.SYSTEMSALLOWLIST ()
B.SYSTEMSGET_PRIVATELINK
C.SYSTEMSAUTHORIZE_PRIVATELINK
D.SYSTEMSALLOWLIST_PRIVATELINK ()

Question 126

Question 127

Question 128

Question 129

Question 130

Download PDF File