[Dec 10, 2023] ARA-C01 Test Engine files, ARA-C01 Dumps PDF

Latest Snowflake ARA-C01 PDF and Dumps (2023) Free Exam Questions Answers

NEW QUESTION # 79
Who can provide permission to EXECUTE TASK?

• A. ACCOUNTADMIN
• B. THE TASK OWNER
• C. SYSADMIN

Answer: A

NEW QUESTION # 80
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin

• A. TRUE
• B. FALSE

Answer: A

NEW QUESTION # 81
Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimization to only a few tables at first) and closely monitoring the costs and benefits.

• A. TRUE
• B. FALSE

Answer: A

NEW QUESTION # 82
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 ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;
• C. GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;
• D. GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;
• E. GRANT ROLE PUBLIC TO ROLE INTERN;

Answer: C,D

NEW QUESTION # 83
Let's say that you have two JSONs as below
1. {"stuId":2000, "stuName":"Amy"}
2. {"stuId":2000,"stuCourse":"Snowflake"}
How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2

• A. with stu_demography as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
• B. SELECT CONTAINS('{"stuId":2000, "stuName":"Amy"}','{"stuId":2000,"stuCourse":"Snowflake"}');
• C. with stu_demography as (select parse_json(column1) as src, src['STUID'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
• D. with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')),
• E. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;

Answer: A,E

NEW QUESTION # 84
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. Only TASK OWNER can provide that privilege to the role.
• B. The role used to resume the task does not have EXECUTE TASK privilege. Only ACCOUNTADMIN can provide that privilege to the role.
• C. The role used to resume the task does not have EXECUTE TASK privilege. Both SECURITYADMIN and ACCOUNTADMIN can provide that privilege to the role.

Answer: B

NEW QUESTION # 85
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.

• A. TRUE
• B. FALSE

Answer: A

NEW QUESTION # 86
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, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
• B. MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
• C. USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
• D. USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db

Answer: C

NEW QUESTION # 87
Which of the below objects cannot be replicated from one region to the other?

• A. Materialized views
• B. Streams
• C. File Formats
• D. Pipes
• E. Views
• F. Sequences

Answer: B,D

NEW QUESTION # 88
What Snowflake features should be leveraged when modeling using Data Vault?

• A. Snowflake's ability to hash keys so that hash key joins can run faster than integer joins
• B. Snowflake's support of multi-table inserts into the data model's Data Vault tables
• C. Data needs to be pre-partitioned to obtain a superior data access performance
• D. Scaling up the virtual warehouses will support parallel processing of new source loads

Answer: D

NEW QUESTION # 89
You ran the below query and it took a long time to run
select itembarcode from checkouts where BIBNUMBER = '2213435';
The clustering information shows the below result.
What can you derive from this information
select system$clustering_information('checkouts','(BIBNUMBER)');

• A. The query is running slow because the warehouse does not have enough memory
• B. The data is not clustered well by BIBNUMBER and it is spread across all the micro-partitions, hence to retrieve a small number of micro-partitions, the query has to scan all the partitions in the table
• C. The query is running slow because BIBNUMBER does not have an index created on it.

Answer: B

NEW QUESTION # 90
You have create a table in snowflake as below
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?

• A. VARCHAR(16777216)
• B. VARCHAR
• C. STRING
• D. VARCHAR(10)

Answer: A

NEW QUESTION # 91
Schema owner can grant object privileges in a regular schema

• A. TRUE
• B. FALSE

Answer: B

NEW QUESTION # 92
You have created a table as below
CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP );
Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE.
Which command below will you choose?

• A. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR)
• B. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR, BLOG_CREATE_DATE);
• C. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_CREATE_DATE);

Answer: B

NEW QUESTION # 93
For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service.
What is this object called?

• A. External procedure
• B. External Script
• C. External function
• D. External job

Answer: C

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

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

Answer: A,C,D

NEW QUESTION # 95
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

• A. Database
• B. Schema
• C. Global
• D. Table

Answer: D

NEW QUESTION # 96
An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect's highest priority is to configure the connector to stream data in the MOST cost-effective manner.
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

• A. Utilize a higher Buffer.flush.time in the connector configuration.
• B. Utilize a higher Buffer.size.bytes in the connector configuration.
• C. Utilize a lower Buffer.count.records in the connector configuration.
• D. Utilize a lower Buffer.size.bytes in the connector configuration.

Answer: C

NEW QUESTION # 97
When would you usually consider to add clustering key to a table

• A. The number of users querying the table has increased
• B. it is a multi-terabyte size table
• C. The table has more than 20 columns
• D. The performance of the query has deteriorated over a period of time.

Answer: B,D

NEW QUESTION # 98
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

• A. TRUE
• B. FALSE

Answer: A

NEW QUESTION # 99
Which of the following are characteristics of Snowflake's parameter hierarchy?

• A. Schema parameters override account parameters.
• B. Table parameters override virtual warehouse parameters.
• C. Session parameters override virtual warehouse parameters.
• D. Virtual warehouse parameters override user parameters.

Answer: C

NEW QUESTION # 100
......

Pass Your SnowPro Advanced Certification ARA-C01 Exam on Dec 10, 2023 with 217 Questions: https://testking.braindumpsit.com/ARA-C01-latest-dumps.html