ARA-C01 exam

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

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:

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 login attempts to Snowflake?A . Call the LOGIN_HISTORY Information Schema table function. B. Query the LOGIN_HISTORY view in the ACCOUNT_USAGE...

A user needs access to create materialized view on a shema mydb.myschema. What is the appropriate command to provide the access?A . GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE; B. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; C. GRANT...