Latest ARA-C01 Actual Free Exam Questions Updated 156 Questions
Free ARA-C01 Exam Braindumps certification guide Q&A
NEW QUESTION 89
select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;
Please select the correct statements for the above-mentioned query.
- A. FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage
- B. FILESTAGE is the file name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage
- C. FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the row number for each record in the container staged data file
Answer: C
NEW QUESTION 90
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 91
Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 92
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 REGULAR VIEW
- B. CREATE A SECURE VIEW
- C. CREATE A MATERIALIZED VIEW AND CLUSTER THE VIEW ON THOSE COLUMNS
Answer: C
NEW QUESTION 93
Which of the below are securable objects?
- A. DATABASE
- B. PRIVILEDGE
- C. TABLE
- D. ROLE
- E. USER
Answer: A,C,D,E
NEW QUESTION 94
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 95
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 96
Which of the below privileges are required for search optimization?
- A. OWNERSHIP privilege on the table
- B. ADD SEARCH OPTIMIZATION privilege on the table.
- C. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
Answer: A,C
NEW QUESTION 97
You have created a table as below
CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR);
What datatype Snowflake will use for EMPLOYEE_ID?
- A. INTEGER
- B. FIXED
- C. NUMBER
Answer: B
NEW QUESTION 98
Which statement is not true about shared database?
- A. Time travel is not supported on a shared database
- B. Shared databases can be re-shared with other accounts
- C. Shared databases cannot be cloned
- D. Shared databases are read only
Answer: B
NEW QUESTION 99
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION 100
You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.
What is the best option?
- A. ALTER TABLE customer_table_other SWAP WITH customer_table
- B. CREATE TABLE customer_table_other CLONE customer_table
- C. CREATE TABLE customer_table_other AS SELECT * FROM customer_table
Answer: B
NEW QUESTION 101
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?
- A. GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
- B. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
- C. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
Answer: A
NEW QUESTION 102
Which command will you run to list all privileges and roles granted to the role
- A. SHOW GRANTS FOR ROLE <ROLE NAME>
- B. SHOW GRANTS ON ROLE <ROLE NAME>
- C. SHOW GRANTS TO ROLE <ROLE NAME>
- D. SHOW GRANTS OF ROLE <ROLE NAME>
Answer: C
NEW QUESTION 103
You ran a query and the query
SELECT * FROM inventory WHERE BIBNUMBER = 2805127;
The query profile looks as below. If you would like to further tune the query, what is the best thing to do?
- A. Create an index on column BIBNUMBER
- B. alter table inventory cluster by (BIBNUMBER);
- C. Execute the below query to enable auto clustering
- D. Divide the table into multiple smaller tables
Answer: B
NEW QUESTION 104
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.
Which are those?
- A. RECORD_MESSAGE
- B. RECORD_METADATA
- C. RECORD_CONTENT
Answer: B,C
NEW QUESTION 105
You have an inventory table. You created two views on this table. The views look like as below
CREATE VIEW NON_SECURE_INVENTORY AS
SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
FROM INVENTORY
WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
CREATE SECURE VIEW SECURE_INVENTORY AS
SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
FROM INVENTORY
WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
You ran the below queries
ALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cache
SELECT * FROM NON_SECURE_INVENTORY WHERE BIBNUMBER =511784; SELECT * FROM SECURE_INVENTORY WHERE BIBNUMBER =511784;
The query profile for the first query looks as below
However, the query profile for the second one looks like as below
Both the views use the same columns from the same underlying view. So, why is this difference in query profiles.
- A. Secure views do not expose the underlying tables or internal structural details for a view
- B. The query is run by a role that did not have access to the view
- C. The query profile is corrupted
Answer: A
NEW QUESTION 106
You can define a clustering key directly on top of VARIANT columns
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION 107
To increase performance, materialized views can be created on external table without any additional cost
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION 108
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 109
Below are the rest APIs provided by Snowpipe
- A. insertFiles
- B. loadData
- C. insertReport
Answer: A,C
NEW QUESTION 110
......
ARA-C01 Certification Overview Latest ARA-C01 PDF Dumps: https://www.actualcollection.com/ARA-C01-exam-questions.html
Top Snowflake ARA-C01 Exam Audio Study Guide! Practice Questions Edition: https://drive.google.com/open?id=1Res1vwiqr7nX8Wh8WRAJgDJGWT4yv28-