ARA-C01 Practice Questions

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

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to l...

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer ro...

A company is following the Data Mesh principles, including domain separation, and chose one Snowflake account for its data platform. An Architect created two data domains to produc...

An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users access the reports using several da...

An Architect is designing a solution that will be used to process changed records in an orders table. Newly-inserted orders must be loaded into the f_orders fact table, which will...

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 using the secondary role?

Two queries are run on the customer_address table: create or replace TABLE CUSTOMER_ADDRESS ( CA_ADDRESS_SK NUMBER(38,0), CA_ADDRESS_ID VARCHAR(16), CA_STREET_NUMBER VARCHAR(IO) CA...

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

One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?

When would you usually consider to add clustering key to a table?

A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?

Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?

For which use cases, will you use cross-cloud and cross-region replication?

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The...

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply ch...

A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

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

What are some of the characteristics of result set caches? (Choose three.)

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to defi...

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization's system. What is the BEST way to find recent and ongoing logi...

An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics. What s...

A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below: Column C4 and C5 are mostly used by SELECT queries in the...

What is the data size limit for loading into a variant column?

Who can view account-level Credit and Storage Usage?

When a database gets cloned, what accesses are replicated?

Which command will you run to list all privileges and roles granted to the role?

The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend ?60 and used exclusively for this task, which statement is true?

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical e...

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect's highest priority is to configure the connector to stre...

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts. The QA account is intended to run and test changes on data...

A user can change object parameters using which of the following roles?

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend...

A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which appro...

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements whi...

An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows: 1) Use Tri-Secret Secure i...

Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

What is a key consideration when setting up search optimization service for a table?

A retail company has 2000+ stores spread across the country. Store Managers report that they are having trouble running key reports related to inventory management, sales targets,...

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availabi...

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend...

When using the copy into <table> command with the CSV file format, how does the match_by_column_name parameter behave?