Free ARA-C01 Exam Files Downloaded Instantly UPDATED [2023]
100% Pass Guaranteed Free ARA-C01 Exam Dumps
NEW QUESTION 31
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.
Which is that role?
- A. IMPORTED PRIVILEGES
- B. IMPORT SHARE
- C. SHARED PRIVILEGES
Answer: A
NEW QUESTION 32
Which metrics below will help you take a decision if you need to resize your warehouse?
- A. QUERY_HISTORY.SCANNED_ROWS
- B. QUERY_HISTORY.BYTES_SCANNED
- C. QUERY_HISTORY.REMOTE_SPILLAGE_BYTES
Answer: B
NEW QUESTION 33
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. Read the last 24 hours of history every minute
- C. Reading the last 10 minutes of history every 8 minutes
Answer: C
NEW QUESTION 34
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost
- A. Materialized View
- B. Clustering the Table
- C. Search Optimization Service
Answer: B
NEW QUESTION 35
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
- A. An error is returned and no changes are applied to the column
- B. Snowflake automatically assigns a default value and let the change happen
- C. Snowflake drops the row and let the change happen
Answer: A
NEW QUESTION 36
For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service.
What is this object called?
- A. External job
- B. External function
- C. External procedure
- D. External Script
Answer: B
NEW QUESTION 37
You have created a table as below
CREATE TABLE TEST_01 (NAME STRING(10));
What data type SNOWFLAKE will assign to column NAME?
- A. STRING
- B. LONGCHAR
- C. VARCHAR
Answer: C
NEW QUESTION 38
You have created a table as below
CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);
Which of the below select query will fail for this table?
- A. SELECT * from snowflake;
- B. SELECT * from Snowflake;
- C. SELECT * from "snowflake";
- D. SELECT * FROM "SNOWFLAKE";
Answer: C
NEW QUESTION 39
Which command will you run to list all privileges and roles granted to the role
- A. SHOW GRANTS OF ROLE <ROLE NAME>
- B. SHOW GRANTS ON ROLE <ROLE NAME>
- C. SHOW GRANTS FOR ROLE <ROLE NAME>
- D. SHOW GRANTS TO ROLE <ROLE NAME>
Answer: D
NEW QUESTION 40
Data replication in snowflake helps in
- A. Disaster recovery
- B. Account Migration
- C. Fail safe
- D. Data sharing
Answer: A,B,D
NEW QUESTION 41
SNOWPIPE_AUTO_INGEST is supported for external stages only
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 42
Which statement is not true about shared database?
- A. Time travel is not supported on a shared database
- B. Shared databases cannot be cloned
- C. Shared databases can be re-shared with other accounts
- D. Shared databases are read only
Answer: C
NEW QUESTION 43
You have a view.
How will you list all the object references of the view?
- A. GET_VIEW_REFERENCES
- B. GET_VIEW_METADATA
- C. GET_OBJECT_REFERENCES
Answer: C
NEW QUESTION 44
Who can provide permission to EXECUTE TASK?
- A. SYSADMIN
- B. THE TASK OWNER
- C. ACCOUNTADMIN
Answer: C
NEW QUESTION 45
Select the true statement
- A. Privileges are granted to both roles and users
- B. Privileges are granted to users. Users are granted to roles
- C. Privileges are granted to roles. Roles are granted to users
Answer: C
NEW QUESTION 46
......
Latest ARA-C01 dumps - Instant Download PDF: https://www.examprepaway.com/Snowflake/braindumps.ARA-C01.ete.file.html
Verified & Latest ARA-C01 Dump Q&As with Correct Answers: https://drive.google.com/open?id=1n7L7zz2-6VWP8WGlxLD6ewbZPvo-HWCi