Snowflake ARA-C01 Practice Exam Questions

Snowflake ARA-C01 Sample Question Answers

Question # 1

A company has a source system that provides JSON records for various loT operations.The JSON Is loading directly into a persistent table with a variant field. The data Is quicklygrowing to 100s of millions of records and performance to becoming an issue. There is ageneric access pattern that Is used to filter on the create_date key within the variant field.What can be done to improve performance?

A. Alter the target table to Include additional fields pulled from the JSON records. Thiswould Include a create_date field with a datatype of time stamp. When this field Is used inthe filter, partition pruning will occur. 
B. Alter the target table to include additional fields pulled from the JSON records. Thiswould include a create_date field with a datatype of varchar. When this field is used in thefilter, partition pruning will occur. 
C. Validate the size of the warehouse being used. If the record count is approaching 100sof millions, size XL will be the minimum size required to process this amount of data. 
D. Incorporate the use of multiple tables partitioned by date ranges. When a user orprocess needs to query a particular date range, ensure the appropriate base table Is used. 

Show Answer

Question # 2

An Architect needs to design a Snowflake account and database strategy to store andanalyze large amounts of structured and semi-structured data. There are many businessunits and departments within the company. The requirements are scalability, security, andcost efficiency.What design should be used?

A. Create a single Snowflake account and database for all data storage and analysisneeds, regardless of data volume or complexity.  
B. Set up separate Snowflake accounts and databases for each department or businessunit, to ensure data isolation and security. 
C. Use Snowflake's data lake functionality to store and analyze all data in a centrallocation, without the need for structured schemas or indexes 
D. Use a centralized Snowflake database for core business data, and use separatedatabases for departmental or project-specific data. 

Show Answer

Question # 3

What are characteristics of the use of transactions in Snowflake? (Select TWO). 

A. Explicit transactions can contain DDL, DML, and query statements.  
B. The autocommit setting can be changed inside a stored procedure.  
C. A transaction can be started explicitly by executing a BEGIN WORK statement andended explicitly by executing a COMMIT WORK statement.
D. A transaction can be started explicitly by executing a BEGIN TRANSACTION statementand ended explicitly by executing an END TRANSACTION statement. 
E. Explicit transactions should contain only DML statements and query statements. All DDLstatements implicitly commit active transactions. 

Show Answer

Question # 4

An Architect needs to design a solution for building environments for development, test,and pre-production, all located in a single Snowflake account. The environments should bebased on production data.Which solution would be MOST cost-effective and performant?

A. Use zero-copy cloning into transient tables.  
B. Use zero-copy cloning into permanent tables.  
C. Use CREATE TABLE ... AS SELECT (CTAS) statements.  
D. Use a Snowflake task to trigger a stored procedure to copy data.  

Show Answer

Question # 5

An Architect is implementing a CI/CD process. When attempting to clone a table from aproduction to a development environment, the cloning operation fails.What could be causing this to happen?

A. The table is transient.  
B. The table has a masking policy.  
C. The retention time for the table is set to zero.  
D. Tables cannot be cloned from a higher environment to a lower environment.  

Show Answer

Question # 6

How can the Snowpipe REST API be used to keep a log of data load history? 

A. Call insertReport every 20 minutes, fetching the last 10,000 entries.  
B. Call loadHistoryScan every minute for the maximum time range.  
C. Call insertReport every 8 minutes for a 10-minute time range.  
D. Call loadHistoryScan every 10 minutes for a 15-minutes range.  

Show Answer

Question # 7

How can the Snowpipe REST API be used to keep a log of data load history? 

A. Call insertReport every 20 minutes, fetching the last 10,000 entries.  
B. Call loadHistoryScan every minute for the maximum time range.  
C. Call insertReport every 8 minutes for a 10-minute time range.  
D. Call loadHistoryScan every 10 minutes for a 15-minutes range.  

Show Answer

Question # 8

A user has activated primary and secondary roles for a session.What operation is the user prohibited from using as part of SQL actions in Snowflake usingthe secondary role?

A. Insert  
B. Create  
C. Delete  
D. Truncate  

Show Answer

Question # 9

A new table and streams are created with the following commands:CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ;CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS;CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY =TRUE;The following operations are processed on the newly created table:INSERT INTO LETTERS VALUES (1, 'A');INSERT INTO LETTERS VALUES (2, 'B');INSERT INTO LETTERS VALUES (3, 'C');TRUNCATE TABLE LETTERS;INSERT INTO LETTERS VALUES (4, 'D');INSERT INTO LETTERS VALUES (5, 'E');INSERT INTO LETTERS VALUES (6, 'F');DELETE FROM LETTERS WHERE ID = 6;What would be the output of the following SQL commands, in order?SELECT COUNT (*) FROM STREAM_1;SELECT COUNT (*) FROM STREAM_2;

A. 2 & 6  
B. 2 & 3  
C. 4 & 3  
D. 4 & 6  

Show Answer

Question # 10

Which columns can be included in an external table schema? (Select THREE). 

A. VALUE  
B. METADATASROW_ID  
C. METADATASISUPDATE  
D. METADAT A$ FILENAME  
E. METADATAS FILE_ROW_NUMBER  
F. METADATASEXTERNAL TABLE PARTITION  

Show Answer