ARA-C01 Practice Questions

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

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

An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server. How can this require...

What transformations are supported in the below SQL statement? (Select THREE). CREATE PIPE ... AS COPY ... FROM (...)

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported. What could be causing this?

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

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would be copying of data be required, and zero-copy cloning no...

A new user user_01 is created within Snowflake. The following two commands are executed: Command 1-> show grants to user user_01; Command 2 ~> show grants on user user 01; What inf...

Which technique will efficiently ingest and consume semi-structured data for Snowflake data lake workloads?

What are characteristics of Dynamic Data Masking? (Select TWO).

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

What is a characteristic of event notifications in Snowpipe?

An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured data. There are many business units and...

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

Database DB1 has schema S1 which has one table, T1. DB1 --> S1 --> T1 The retention period of EG1 is set to 10 days. The retention period of s: is set to 20 days. The retention per...

A global company needs to securely share its sales and Inventory data with a vendor using a Snowflake account. The company has its Snowflake account In the AWS eu-west 2 Europe (Lo...

A company wants to Integrate its main enterprise identity provider with federated authentication with Snowflake. The authentication integration has been configured and roles have b...

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loa...

A table, EMP_ TBL has three records as shown: The following variables are set for the session: Which SELECT statements will retrieve all three records? (Select TWO).

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of thes...

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

An Architect Is designing a data lake with Snowflake. The company has structured, semi- structured, and unstructured data. The company wants to save the data inside the data lake w...

Consider the following scenario where a masking policy is applied on the CREDICARDND column of the CREDITCARDINFO table. The masking policy definition Is as follows: Sample data fo...

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in t...

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME. What is...

A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish: What would be the output of this query?

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a times...

An Architect needs to automate the daily Import of two files from an external stage into Snowflake. One file has Parquet-formatted data, the other has CSV-formatted data. How shoul...

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 quickly...

An Architect has a design where files arrive every 10 minutes and are loaded into a primary database table using Snowpipe. A secondary database is refreshed every hour with the lat...

An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers. The weathe...

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; CREAT...

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?

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

An Architect is designing a data lake with Snowflake. The company has structured, semi- structured, and unstructured data. The company wants to save the data inside the data lake w...

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 S...

An Architect with the ORGADMIN role wants to change a Snowflake account from an Enterprise edition to a Business Critical edition. How should this be accomplished?

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

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 be...

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but...

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority...

Role A has the following permissions: - USAGE on db1 - USAGE and CREATE VIEW on schemal in db1 - SELECT on tablel in schemal Role B has the following permissions: - USAGE on db2 -...

What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

What is the MOST efficient way to design an environment where data retention is not considered critical, and customization needs are to be kept to a minimum?

A retailer's enterprise data organization is exploring the use of Data Vault 2.0 to model its data lake solution. A Snowflake Architect has been asked to provide recommendations fo...

A company is designing a process for importing a large amount of loT JSON data from cloud storage into Snowflake. New sets of loT data get generated and uploaded approximately ever...

Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?