Snowflake ARA-C01 Dumps

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

Question # 11

A company needs to share its product catalog data with one of its partners. The productcatalog data is stored in two database tables: product_category, and product_details. Bothtables can be joined by the product_id column. Data access should be governed, and onlythe partner should have access to the records.The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.Which design will be the MOST cost-effective and secure, while using the requiredSnowflake features?

A. Use Secure Data Sharing with an S3 bucket as a destination.  
B. Publish product_category and product_details data sets on the Snowflake Marketplace.  
C. Create a database user for the partner and give them access to the required data sets.  
D. Create a reader account for the partner and share the data sets as secure views.  

Show Answer

Question # 12

Why might a Snowflake Architect use a star schema model rather than a 3NF model whendesigning a data architecture to run in Snowflake? (Select TWO).

A. Snowflake cannot handle the joins implied in a 3NF data model.  
B. The Architect wants to remove data duplication from the data stored in Snowflake.  
C. The Architect is designing a landing zone to receive raw data into Snowflake.  
D. The Bl tool needs a data model that allows users to summarize facts across differentdimensions, or to drill down from the summaries. 
E. The Architect wants to present a simple flattened single view of the data to a particulargroup of end users. 

Show Answer

Question # 13

A company has a Snowflake environment running in AWS us-west-2 (Oregon). Thecompany needs to share data privately with a customer who is running their Snowflakeenvironment in Azure East US 2 (Virginia).What is the recommended sequence of operations that must be followed to meet thisrequirement?

A. 1. Create a share and add the database privileges to the share2. Create a new listing onthe Snowflake Marketplace3. Alter the listing and add the share4. Instruct the customer tosubscribe to the listing on the Snowflake Marketplace
B. 1. Ask the customer to create a new Snowflake account in Azure EAST US 2 (Virginia)2.Create a share and add the database privileges to the share3. Alter the share and add thecustomer's Snowflake account to the share  
C. 1. Create a new Snowflake account in Azure East US 2 (Virginia)2. Set up replicationbetween AWS us-west-2 (Oregon) and Azure East US 2 (Virginia) for the database objectsto be shared3. Create a share and add the database privileges to the share4. Alter theshare and add the customer's Snowflake account to the share 
D. 1. Create a reader account in Azure East US 2 (Virginia)2. Create a share and add thedatabase privileges to the share3. Add the reader account to the share4. Share the readeraccount's URL and credentials with the customer 

Show Answer

Question # 14

An Architect needs to design a data unloading strategy for Snowflake, that will be used withthe COPY INTO <location> command.Which configuration is valid?

A. Location of files: Snowflake internal location. File formats: CSV, XML. File encoding:UTF-8. Encryption: 128-bit 
B. Location of files: Amazon S3. File formats: CSV, JSON. File encoding: Latin-1 (ISO8859). Encryption: 128-bit
C. Location of files: Google Cloud Storage. File formats: Parquet. File encoding: UTF-8·Compression: gzip 
D. Location of files: Azure ADLS. File formats: JSON, XML, Avro, Parquet, ORC.Compression: bzip2. Encryption: User-supplied key 

Show Answer

Question # 15

What step will im the performance of queries executed against an external table? 

A. Partition the external table.  
B. Shorten the names of the source files.  
C. Convert the source files' character encoding to UTF-8.  
D. Use an internal stage instead of an external stage to store the source files.  

Show Answer

Question # 16

A Snowflake Architect is setting up database replication to support a disaster recoveryplan. The primary database has external tables.How should the database be replicated?

A. Create a clone of the primary database then replicate the database.  
B. Move the external tables to a database that is not replicated, then replicate the primary database. 
C. Replicate the database ensuring the replicated database is in the same region as theexternal tables. 
D. Share the primary database with an account in the same region that the database will bereplicated to. 

Show Answer

Question # 17

An Architect needs to meet a company requirement to ingest files from the company'sAWS storage accounts into the company's Snowflake Google Cloud Platform (GCP)account. How can the ingestion of these files into the company's Snowflake account beinitiated? (Select TWO).

A. Configure the client application to call the Snowpipe REST endpoint when new fileshave arrived in Amazon S3 storage.
B. Configure the client application to call the Snowpipe REST endpoint when new fileshave arrived in Amazon S3 Glacier storage. 
C. Create an AWS Lambda function to call the Snowpipe REST endpoint when new fileshave arrived in Amazon S3 storage. 
D. Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new fileshave arrived in Amazon S3 storage. 
E. Configure the client application to issue a COPY INTO <TABLE> command toSnowflake when new files have arrived in Amazon S3 Glacier storage. 

Show Answer

Question # 18

A Snowflake Architect is designing an application and tenancy strategy for an organizationwhere strong legal isolation rules as well as multi-tenancy are requirements.Which approach will meet these requirements if Role-Based Access Policies (RBAC) is aviable option for isolating tenants?

A. Create accounts for each tenant in the Snowflake organization.  
B. Create an object for each tenant strategy if row level security is viable for isolating tenants. 
C. Create an object for each tenant strategy if row level security is not viable for isolating tenants. 
D. Create a multi-tenant table strategy if row level security is not viable for isolating tenants.  

Show Answer

Question # 19

The following table exists in the production database:A regulatory requirement states that the company must mask the username for events thatare older than six months based on the current date when the data is queried.How can the requirement be met without duplicating the event data and making sure it isapplied when creating views using the table or cloning the table?

A. Use a masking policy on the username column using a entitlement table with valid dates. 
B. Use a row level policy on the user_events table using a entitlement table with valid dates. 
C. Use a masking policy on the username column with event_timestamp as a conditional column. 
D. Use a secure view on the user_events table using a case statement on the username column. 

Show Answer

Question # 20

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-minute time range.  

Show Answer