[2023] Valid ARA-C01 test answers & Snowflake ARA-C01 exam pdf [Q62-Q79]

Q62. With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute

Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes.

Only if the system estimates there’s enough query load to keep the cluster busy for at least 4 minutes.

Q63. Snowflake supports the following query performance optimizing methods

Caching techniques

Retrieving results of previous query from cache

B-tree type indexes

Q64. For authentication, snowflake Kafka connector relies on:

key pair authentication

username/password

Both key pair authentication and username/password

Q65. Multi-cluster warehouses are best utilized for

Scaling resources to improve concurrency for users/queries

Improving the performance of slow-running queries

Improving the performance of data loading

Q66. Which command below will only copy the table structure from the existing table to the new table?

CREATE TABLE … AS SELECT

CREATE TABLE … LIKE

CREATE TABLE … CLONE

Q67. Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.
Which are those?

RECORD_CONTENT

RECORD_METADATA

RECORD_MESSAGE

Q68. You need to choose a high cardinality column for the clustering key

TRUE

FALSE

Q69. Search optimization does not support Materialized views and External Tables

TRUE

FALSE

Q70. What does Percentage scanned from cache in the query profile signify?

The percentage of data scanned from the local disk cache

The percentage of data scanned from the METADATA cache

The percentage of data scanned from the QUERY cache

Q71. create or replace table result_scan_table as
select * from table(result_scan(last_query_id()));
Will the above query cost you any compute credits?

It will not cost any compute credit because this query is a metadata operation

It will cost compute credit because processing is required to insert the data into result_scan_table

It will depend on the warehouse chosen

Q72. select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;
Please select the correct statements for the above-mentioned query.

FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the row number for each record in the container staged data file

FILESTAGE is the file name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage

FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage

Q73. Which statement is true about clustering key?

Clustering key can be one per table but the key can have more than one column

Clustering key can be many per table and each key can have more than one column

Clustering key can be many per table but each key can have only one column

Q74. Which of the below objects cannot be replicated from one region to the other?

File Formats

Sequences

Pipes

Views

Materialized views

Streams

Q75. The insertReport endpoint can be thought of like the UNIX command tail

TRUE

FALSE

Q76. 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 temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE

Only the STUDENT_TABLE_CLONE will be created, the other one will be deleted

You will get an error as below

SQL compilation error: Temp table cannot be cloned to a permanent table; clone to a transient table instead.

Q77. Which of the below commands will use warehouse credits?

SHOW TABLES LIKE ‘SNOWFL%’;

SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

SELECT COUNT(*) FROM SNOWFLAKE;

SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Q78. COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV

GZIP

BZ2