ARA-C01 exam

Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%'; B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE; C. SELECT COUNT(*) FROM SNOWFLAKE; D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...

For which use cases, will you use cross-cloud and cross-region replication?A . Business continuity and disaster recovery B. Secure data sharing across regions/cloud C. Data portability and account migrations D. All of theseView AnswerAnswer: D Explanation: All of these are uses cases for cross-cloud/region replication

You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.A...

For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.A . FALSE B. TRUEView AnswerAnswer: B Explanation: PATTERN = 'regex_pattern' A regular expression pattern string, enclosed in single quotes, specifying the file names and/or paths...

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?A . CONTINUE B. SKIP_FILE C. ABORT_STATEMENT D. FAILView AnswerAnswer: A,B,C Explanation: Copy Options (copyOptions) You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):...

Which of the below are securable objects?A . USER B. ROLE C. PRIVILEDGE D. TABLE E. DATABASEView AnswerAnswer: A,B,D,E Explanation: Securable object is an entity to which access can be granted. Unless allowed by a grant, access will be denied Every securable object resides within a logical container in a...

Which command below will only copy the table structure from the existing table to the new table?A . CREATE TABLE … AS SELECT B. CREATE TABLE … LIKE C. CREATE TABLE … CLONEView AnswerAnswer: B Explanation: CREATE TABLE … LIKE Creates a new table with the same column definitions as...

What will the below query return SELECT TOP 10 GRADES FROM STUDENT;A . The top 10 highest grades B. The 10 lowest grades C. Non-deterministic list of 10 gradesView AnswerAnswer: C Explanation: An ORDER BY clause is not required; however, without an ORDER BY clause, the results are non-deterministic because...

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

It is recommended to assign ACCOUNTADMIN role to atleast two userA . TRUE B. FALSEView AnswerAnswer: A Explanation: Control the Assignment of the ACCOUNTADMIN Role to Users We strongly recommend the following precautions when assigning the ACCOUNTADMIN role to users: Assign this role only to a select/limited number of people...