Online Access Free ARA-C01 Practice Test

A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AWS Singapore region that the team wants to analyze.
The Architect has been given the following requirements:
1. Provide access to frequently changing data
2. Keep egress costs to a minimum
3. Maintain low latency
How can these requirements be met with the LEAST amount of operational overhead?

• A.Use an external table against the S3 bucket in AWS Singapore and copy the data into transient tables.
• B.Use AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an Azure Netherlands Blob storage, then use an external table against the Blob storage.
• C.Use a materialized view on top of an external table against the S3 bucket in AWS Singapore.
• D.Copy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe for data ingestion.

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 this to happen?

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

A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the 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 required Snowflake features?

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

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

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

A retail company has over 3000 stores all using the same Point of Sale (POS) system. The company wants to deliver near real-time sales results to category managers. The stores operate in a variety of time zones and exhibit a dynamic range of transactions each minute, with some stores having higher sales volumes than others.
Sales results are provided in a uniform fashion using data engineered fields that will be calculated in a complex data pipeline. Calculations include exceptions, aggregations, and scoring using external functions interfaced to scoring algorithms. The source data for aggregations has over 100M rows.
Every minute, the POS sends all sales transactions files to a cloud storage location with a naming convention that includes store numbers and timestamps to identify the set of transactions contained in the files. The files are typically less than 10MB in size.
How can the near real-time results be provided to the category managers? (Select TWO).

• A.The copy into command with a task scheduled to run every second should be used to achieve the near- real time requirement.
• B.A stream should be created to accumulate the near real-time data and a task should be created that runs at a frequency that matches the real-time analytics needs.
• C.An external scheduler should examine the contents of the cloud storage location and issue SnowSQL commands to process the data at a frequency that matches the real-time analytics needs.
• D.A Snowpipe should be created and configured with AUTO_INGEST = true. A stream should be created to process INSERTS into a single target table using the stream metadata to inform the store number and timestamps.
• E.All files should be concatenated before ingestion into Snowflake to avoid micro-ingestion.