Free Snowflake ARA-C01 Exam Dumps Questions & Answers

A new table and streams are created with the following commands:
CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ;
CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS;
CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY = TRUE;
The following operations are processed on the newly created table:
INSERT INTO LETTERS VALUES (1, 'A');
INSERT INTO LETTERS VALUES (2, 'B');
INSERT INTO LETTERS VALUES (3, 'C');
TRUNCATE TABLE LETTERS;
INSERT INTO LETTERS VALUES (4, 'D');
INSERT INTO LETTERS VALUES (5, 'E');
INSERT INTO LETTERS VALUES (6, 'F');
DELETE FROM LETTERS WHERE ID = 6;
What would be the output of the following SQL commands, in order?
SELECT COUNT (*) FROM STREAM_1;
SELECT COUNT (*) FROM STREAM_2;

• A.  4 & 6
• B.  4 & 3
• C.  2 & 6
• D.  2 & 3

A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.

The general query patterns for the table are:
1. DeviceId, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement
2. The columns City and DeviceManuf acturer are often retrieved
3. There is often a count on Uniqueld
Which field(s) should be used for the clustering key?

• A.  Deviceld and Customerld
• B.  City and DeviceManuf acturer
• C.  Uniqueld
• D.  lOT_timestamp

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

• A.  CONTINUE
• B.  SKIP_FILE
• C.  FAIL
• D.  ABORT_STATEMENT

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

• A.  USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db
• B.  USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
• C.  MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
• D.  USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db

An Architect executes the following statements in order:
CREATE TABLE emp (id INTEGER);
INSERT INTO emp VALUES (1),(2);
CREATE TEMPORARY TABLE emp (id INTEGER);
INSERT INTO emp VALUES (1);
Then executes:
SELECT COUNT(*) FROM emp;
DROP TABLE emp;
SELECT COUNT(*) FROM emp;
What will be the result?

• A.  COUNT() = 2
  COUNT() = 1
• B.  COUNT() = 1
  COUNT() = 2
• C.  COUNT() = 2
  COUNT() = 2
• D.  The final query results in an error.