Free Access to Snowflake.ARA-C01.v2026-04-11.q236 with Valid Practice Test (Page 17)

Question 76

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

A.An external table
B.A pipe
C.A stream
D.A copy command at regular intervals

Correct Answer: B

* A pipe is a Snowflake object that continuously loads data from files in a stage (internal or external) into a table. A pipe can be configured to use auto-ingest, which means that Snowflake automatically detects new or modified files in the stage and loads them into the table without any manual intervention1.
* A pipe is the most cost-effective way to bring large numbers of small JSON files into a Snowflake table, because it minimizes the number of COPY commands executed and the number of micro- partitions created. A pipe can use file aggregation, which means that it can combine multiple small files into a single larger file before loading them into the table. This reduces the load time and the storage cost of the data2.
* An external table is a Snowflake object that references data files stored in an external location, such as Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage. An external table does not store the data in Snowflake, but only provides a view of the data for querying. An external table is not a cost- effective way to bring data into a Snowflake table, because it does not support file aggregation, and it requires additional network bandwidth and compute resources to query the external data3.
* A stream is a Snowflake object that records the history of changes (inserts, updates, and deletes) made to a table. A stream can be used to consume the changes from a table and apply them to another table or a task. A stream is not a way to bring data into a Snowflake table, but a way to process the data after it is loaded into a table4.
* A copy command is a Snowflake command that loads data from files in a stage into a table. A copy command can be executed manually or scheduled using a task. A copy command is not a cost-effective way to bring large numbers of small JSON files into a Snowflake table, because it does not support file aggregation, and it may create many micro-partitions that increase the storage cost of the data5.
Pipes : Loading Data Using Snowpipe : External Tables : Streams : COPY INTO <table>

Question 77

An Architect runs the following SQL query:

How can this query be interpreted?

A.FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.
B.FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.
C.FILEROWS is a file. FILE_ROW_NUMBER is the file format location.
D.FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

Question 78

Which of the below query will you run to get the approximate number of distinct values in a table?

A.select count_distinct(column1 approx) from table1;
B.select approx_count(column1) from table1;
C.select approx_count_distinct(column1) from table1;

Question 79

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

A.Clone a table from a share.
B.Grant modify permissions on the share.
C.Create a table from the shared database.
D.Create additional views inside the shared database.
E.Create a table stream on the shared table.

Question 80

A user, analyst_user has been granted the analyst_role, and is deploying a SnowSQL script to run as a background service to extract data from Snowflake.
What steps should be taken to allow the IP addresses to be accessed? (Select TWO).

A.ALTERROLEANALYST_ROLESETNETWORK_POLICY='ANALYST_POLICY';
B.ALTERUSERANALYSTJJSERSETNETWORK_POLICY='ANALYST_POLICY';
C.ALTERUSERANALYST_USERSETNETWORK_POLICY='10.1.1.20';
D.USE ROLE SECURITYADMIN;CREATE OR REPLACE NETWORK POLICY
ANALYST_POLICY ALLOWED_IP_LIST = ('10.1.1.20');
E.USE ROLE USERADMIN;CREATE OR REPLACE NETWORK POLICYANALYST_POLICYALLOWED_IP_LIST = ('10.1.1.20');

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File