ARA-C01

Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:

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:

If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...

To increase performance, materialized views can be created on external table without any additional costA . TRUE B. FALSEView AnswerAnswer: B Explanation: Materialized views are designed to improve query performance for workloads composed of common, repeated query patterns. However, materializing intermediate results incurs additional costs. As such, before creating any...

When does a multi-cluster warehouse shuts down with default scaling policyA . Immediately after the query is run B. After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up...

Which of the below privileges are required for search optimization?A . OWNERSHIP privilege on the table B. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table C. ADD SEARCH OPTIMIZATION privilege on the table.View AnswerAnswer: A,B Explanation: What Access Control Privileges Are Needed For the Search Optimization Service?

Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: The SELECT statement used for transformations does not support all functions. For a complete list of the supported...

Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:

Privileges granted on database objects are not replicated to a secondary database.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Access Control Privileges granted on database objects are not replicated to a secondary database. https://docs.snowflake.com/en/user-guide/database-replication-intro.html#access-control

Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.A . TRUE B. FALSEView AnswerAnswer: A Explanation: All files stored in internal stages (for data loading/unloading) automatically encrypted (using either AES 128 standard or 256 strong encryption). https://docs.snowflake.com/en/user-guide/admin-security.html Please note if using external...