ARA-C01 exam

Materialized views based on external tables can improve query performanceA . TRUE B. FALSEView AnswerAnswer: A Explanation: Querying data stored external to the database is likely to be slower than querying native database tables; however, materialized views based on external tables can improve query performance. https://docs.snowflake.com/en/user-guide/tables-external-intro.html

You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...

What Snowflake features should be leveraged when modeling using Data Vault?A . Snowflake’s support of multi-table inserts into the data model’s Data Vault tables B. Data needs to be pre-partitioned to obtain a superior data access performance C. Scaling up the virtual warehouses will support parallel processing of new source...

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 to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers...

The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream. B. The warehouse...

Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:

Which alter command below may affect the availability of column with respect to time travel?A . ALTER TABLE...DROP COLUMN B. ALTER TABLE...SET DATA TYPE C. ALTER TABLE...SET DEFAULTView AnswerAnswer: B Explanation: If the precision of a column is decreased below the maximum precision of any column data retained in Time...

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)A . CSV B. XML C. Avro D. JSON E. ParquetView AnswerAnswer: C,D

An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?A . Search optimization service B. Materialized view C. Time Travel D. Zero-copy cloning E. Secure viewsView AnswerAnswer: D

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 authenticate to Snowflake?A . 1) OAuth (either Snowflake OAuth or External OAuth) 2) External browser 3) Okta native authentication 4) Key Pair Authentication, mostly used...