ARA-C01 Practice Questions

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

Which Snowflake data modeling approach is designed for BI queries?

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges...

A company's daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements t...

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What command will accom...

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the comp...

A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?

What Snowflake features should be leveraged when modeling using Data Vault?

A company's client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications aut...

What is a valid object hierarchy when building a Snowflake environment?

Which of the following are characteristics of Snowflake's parameter hierarchy?

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Whic...

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. Th...

What are purposes for creating a storage integration? (Choose three.)

A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Wh...

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permi...

An Architect runs the following SQL query: How can this query be interpreted?

An Architect entered the following commands in sequence: USER1 cannot find the table. Which of the following commands does the Architect need to run for USER1 to find the tables us...

A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the re...

Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in...

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files ar...

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company's busine...

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Eve...

Following objects can be cloned in snowflake

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

Which of the below commands will use warehouse credits?

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with thei...

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).

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

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running. Why is this occurring?

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?

An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Ope...

A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows. The general query patterns for the table are: 1...

Which Snowflake objects can be used in a data share? (Select TWO).

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure. What would be the MOST efficient way to load data from...

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

The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps: Step 1: Data files are loaded in a stage. Step 2...

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can t...

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

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

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes...

A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that a...

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

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME....

A Snowflake Architect is designing a multiple-account design strategy. This strategy will be MOST cost-effective with which scenarios? (Select TWO).

The following table exists in the production database: A regulatory requirement states that the company must mask the username for events that are older than six months based on th...