Free Access to Snowflake.ARA-C01.v2024-12-26.q155 with Valid Practice Test (Page 5)

Question 16

You have created a table as below
CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);
Which of the below select query will fail for this table?

A.SELECT * from Snowflake;
B.SELECT * from "snowflake";
C.SELECT * FROM "SNOWFLAKE";
D.SELECT * from snowflake;

Question 17

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

A.All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
B.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
C.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
D.All rows loaded using a specific COPY statement will have the same timestamp value.

Question 18

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?

A.Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
B.Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C.Setup data replication to the region and cloud platform where the consumer resides.
D.Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

Correct Answer: C

Explanation
According to the SnowPro Advanced: Architect documents and learning resources, the requirement to allow data sharing between two companies that are not on the same cloud platform is to set up data replication to the region and cloud platform where the consumer resides. Data replication is a feature of Snowflake that enables copying databases across accounts in different regions and cloud platforms. Data replication allows data providers to securely share data with data consumers across different regions and cloud platforms by creating a replica database in the consumer's account. The replica database is read-only and automatically synchronized with the primary database in the provider's account. Data replication is useful for scenarios where data sharing is not possible or desirable due to latency, compliance, or security reasons1. The other options are incorrect because they are not required or feasible to allow data sharing between two companies that are not on the same cloud platform. Option A is incorrect because creating a pipeline to write shared data to a cloud storage location in the target cloud provider is not a secure or efficient way of sharing data. It would require additional steps to load the data from the cloud storage to the consumer's account, and it would not leverage the benefits of Snowflake's data sharing features. Option B is incorrect because ensuring that all views are persisted is not relevant for data sharing across cloud platforms. Views can be shared across cloud platforms as long as they reference objects in the same database. Persisting views is an option to improve the performance of querying views, but it is not required for data sharing2. Option D is incorrect because Company A and Company B do not need to agree to use a single cloud platform. Data sharing is possible across different cloud platforms using data replication or other methods, such as listings or auto-fulfillment3. References: ReplicatingDatabases Across Multiple Accounts | Snowflake Documentation, Persisting Views | Snowflake Documentation, Sharing Data Across Regions and Cloud Platforms | Snowflake Documentation

Question 19

Which of the two are limitations of the insertReport API of SnowPipe?

A.Events are retained for a maximum of 10 minutes
B.The 10,000 most recent events are retained
C.Events are retained for a maximum of 24 hours

Question 20

select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;
Please select the correct statements for the above-mentioned query.

A.FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the row number for each record in the container staged data file
B.FILESTAGE is the file name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage
C.FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File