Jan-2024 Pass Snowflake ARA-C01 Exam in First Attempt Easily
Free ARA-C01 Exam Files Downloaded Instantly 100% Dumps & Practice Exam
To take the Snowflake ARA-C01 exam, candidates must have previously passed the SnowPro Core Certification and have significant experience working with Snowflake's cloud data warehouse platform. ARA-C01 exam consists of 60 multiple-choice questions and must be completed within 90 minutes. A passing score of 80% or higher is required to earn the SnowPro Advanced Architect Certification, which is recognized by organizations worldwide as a validation of advanced skill and knowledge in Snowflake data warehousing.
Snowflake ARA-C01 (SnowPro Advanced Architect Certification) Exam is a certification exam designed for professionals who want to demonstrate their advanced-level skills in Snowflake architecture and design. It is a comprehensive exam that covers various topics such as data modeling, data warehousing, data security, performance optimization, and Snowflake administration.
NEW QUESTION # 10
How does a standard virtual warehouse policy work in Snowflake?
- A. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.
- B. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.
- C. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.
- D. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
Answer: D
NEW QUESTION # 11
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. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 12
Which statement is not true about shared database?
- A. Shared databases are read only
- B. Shared databases cannot be cloned
- C. Time travel is not supported on a shared database
- D. Shared databases can be re-shared with other accounts
Answer: D
NEW QUESTION # 13
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.
This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?
- A. The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.
- B. The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.
- C. The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.
- D. The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.
Answer: D
NEW QUESTION # 14
A company has a table with that has corrupted data, named Dat
a. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel.
What command will accomplish this?
- A. CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
- B. CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);
- C. CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
- D. CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
Answer: C
NEW QUESTION # 15
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.
- A. The post can contain unlimited number of files.
- B. The post can contain at most 5000 files.
- C. Each file path given must be <= 1024 bytes long when serialized as UTF-8
Answer: B,C
NEW QUESTION # 16
How do you refresh a materialized view?
- A. ALTER VIEW <MV_NAME> REFRESH
- B. Materialized views are automatically refreshed by snowflake and does not require manual intervention
- C. REFRESH MATERIALIZED VIEW <MV_NAME>
Answer: B
NEW QUESTION # 17
Databases created from shares cannot be replicated
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 18
Snowflake includes administration settings for resource consumption in order to
- A. Help control costs associated with unexpected credit usage of data
- B. Maintain data availability
- C. Manage access to data warehouses for specific users
Answer: A
NEW QUESTION # 19
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.
Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)
- A. COPY INTO tablea FROM @%tablea FORCE = TRUE;
- B. COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
- C. COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
- D. COPY INTO tablea FROM @%tablea FILES = ('file5.csv');
- E. COPY INTO tablea FROM @%tablea MERGE = TRUE;
- F. COPY INTO tablea FROM @%tablea;
Answer: B,F
NEW QUESTION # 20
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. SQL compilation error: Temp table cannot be cloned to a permanent table; clone to a transient table instead.
- B. You will get an error as below
- C. A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE
- D. Only the STUDENT_TABLE_CLONE will be created, the other one will be deleted
Answer: A
NEW QUESTION # 21
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan
- A. Read the last 7 days of history every hour
- B. Reading the last 10 minutes of history every 8 minutes
- C. Read the last 24 hours of history every minute
Answer: B
NEW QUESTION # 22
Which of the below query will you run to get the approximate number of distinct values in a table?
- A. select approx_count_distinct(column1) from table1;
- B. select approx_count(column1) from table1;
- C. select count_distinct(column1 approx) from table1;
Answer: A
NEW QUESTION # 23
You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
What type of table you will use in this case to optimize cost
- A. TRANSIENT
- B. PERMANENT
- C. TEMPORARY
Answer: A
NEW QUESTION # 24
An Architect entered the following commands in sequence:
USER1 cannot find the table.
Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)
- A. GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;
- B. GRANT ROLE PUBLIC TO ROLE INTERN;
- C. GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;
- D. GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;
- E. GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;
Answer: D,E
NEW QUESTION # 25
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?
- A. Not more than 16
- B. 0
- C. 3 to 4
- D. Unlimited
Answer: C
NEW QUESTION # 26
Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.
- A. STRIP_JSON
- B. PARSE_JSON
- C. PARSE_XML
Answer: B
NEW QUESTION # 27
Multi-cluster warehouses are best utilized for
- A. Improving the performance of data loading
- B. Scaling resources to improve concurrency for users/queries
- C. Improving the performance of slow-running queries
Answer: B
NEW QUESTION # 28
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the table which they will query using complex aggregation logic. You know that querying with those columns will take a lot of time because the table is not clustered on those columns.
What is the most optimal solution that you will suggest to the business team?
- A. CREATE A MATERIALIZED VIEW AND CLUSTER THE VIEW ON THOSE COLUMNS
- B. CREATE A REGULAR VIEW
- C. CREATE A SECURE VIEW
Answer: A
NEW QUESTION # 29
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) Okta native authentication
2) Key Pair Authentication, mostly used for production environment users
3) Password
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO - B. 1) External browser, SSO
2) Key Pair Authentication, mostly used for development environment users
3) Okta native authentication
4) OAuth (ether Snowflake OAuth or External OAuth)
5) Password - C. 1) Password
2) Key Pair Authentication, mostly used for production environment users
3) Okta native authentication
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO - D. 1) OAuth (either Snowflake OAuth or External OAuth)
2) External browser
3) Okta native authentication
4) Key Pair Authentication, mostly used for service account users
5) Password
Answer: B
NEW QUESTION # 30
Which of the below objects cannot be replicated from one region to the other?
- A. File Formats
- B. Pipes
- C. Streams
- D. Sequences
- E. Views
- F. Materialized views
Answer: B,C
NEW QUESTION # 31
You are creating a TASK to query a table streams created on the raw table and insert subsets of rows into multiple tables. You are following the below steps, but when you reached the step to resume the task, you received an error message as below.
Why is this error thrown and who can give you the required privilege?
Steps to be followed to get this error
-- Create a landing table to store raw JSON data.
-- Snowpipe could load data into this table. create or replace table raw (var variant);
-- Create a stream to capture inserts to the landing table.
-- A task will consume a set of columns from this stream. create or replace stream rawstream1 on table raw;
-- Create a second stream to capture inserts to the landing table.
-- A second task will consume another set of columns from this stream. create or replace stream rawstream2 on table raw;
-- Create a table that stores the names of office visitors identified in the raw data. create or replace table names (id int, first_name string, last_name string);
-- Create a table that stores the visitation dates of office visitors identified in the raw data.
create or replace table visits (id int, dt date);
-- Create a task that inserts new name records from the rawstream1 stream into the names table
-- every minute when the stream contains records.
-- Replace the 'mywh' warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_names
warehouse = etl_wh
schedule = '1 minute'
when
system$stream_has_data('rawstream1')
as
merge into names n
using (select var:id id, var:fname fname, var:lname lname from rawstream1) r1 on n.id = to_number(r1.id)
when matched then update set n.first_name = r1.fname, n.last_name = r1.lname
when not matched then insert (id, first_name, last_name) values (r1.id, r1.fname, r1.lname)
;
-- Create another task that merges visitation records from the rawstream1 stream into the visits table
-- every minute when the stream contains records.
-- Records with new IDs are inserted into the visits table;
-- Records with IDs that exist in the visits table update the DT column in the table.
-- Replace the 'mywh' warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_visits
warehouse = etl_wh schedule = '1 minute' when
system$stream_has_data('rawstream2') as
merge into visits v
using (select var:id id, var:visit_dt visit_dt from rawstream2) r2 on v.id = to_number(r2.id) when matched then update set v.dt = r2.visit_dt
when not matched then insert (id, dt) values (r2.id, r2.visit_dt);
-- Resume both tasks.
alter task raw_to_names resume;
- A. The role used to resume the task does not have EXECUTE TASK privilege. Both SECURITYADMIN and ACCOUNTADMIN can provide that privilege to the role.
- B. The role used to resume the task does not have EXECUTE TASK privilege. Only TASK OWNER can provide that privilege to the role.
- C. The role used to resume the task does not have EXECUTE TASK privilege. Only ACCOUNTADMIN can provide that privilege to the role.
Answer: C
NEW QUESTION # 32
......
Free Exam Updates ARA-C01 dumps with test Engine Practice: https://www.prep4sureguide.com/ARA-C01-prep4sure-exam-guide.html
Updated Verified ARA-C01 dumps Q&As - 100% Pass Guaranteed: https://drive.google.com/open?id=1uXht4vI6DeHdqbJwXUii0g8VX7d36YFV