[UPDATED 2023] Read ARA-C01 Study Guide Cover to Cover as Literally
100% Real & Accurate ARA-C01 Questions and Answers with Free and Fast Updates
NEW QUESTION # 51
Data replication in snowflake helps in
- A. Fail safe
- B. Data sharing
- C. Disaster recovery
- D. Account Migration
Answer: B,C,D
NEW QUESTION # 52
A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins.
What Snowflake functionality should be used to meet these requirements? (Choose two.)
- A. Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.
- B. Set up SSO for federated authentication.
- C. Set up replication to allow users to connect from outside the company VPN.
- D. Provision a unique company Tri-Secret Secure key.
- E. Use private connectivity from a cloud provider.
Answer: A,D
NEW QUESTION # 53
What does Percentage scanned from cache in the query profile signify?
- A. The percentage of data scanned from the METADATA cache
- B. The percentage of data scanned from the QUERY cache
- C. The percentage of data scanned from the local disk cache
Answer: C
NEW QUESTION # 54
Dynamic data masking is supported in which editions of snowflake
- A. Standard
- B. VPS
- C. Business Critical
- D. Enterprise
Answer: B,C,D
NEW QUESTION # 55
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.
Which are those?
- A. RECORD_MESSAGE
- B. RECORD_CONTENT
- C. RECORD_METADATA
Answer: B,C
NEW QUESTION # 56
While choosing a cluster key, what is recommended by snowflake?
- A. Cluster columns that are most actively used in selective filters
- B. Choose a key with high cardinality
- C. If there is room for additional cluster keys, then consider columns frequently used in join predicates
Answer: A,C
NEW QUESTION # 57
Remote service in external function can be an AWS Lambda function
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 58
An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
What should the Architect do to enable the Snowflake search optimization service on this table?
- A. Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.
- B. Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
- C. Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
- D. Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.
Answer: B
NEW QUESTION # 59
Refreshing a secondary database is not allowed in the following circumstances
- A. Primary database contains transient tables
- B. Databases created from shares
- C. Primary database has external table
- D. Materialized views
Answer: B,C
NEW QUESTION # 60
Which command do you run to remove files from stage?
- A. CLEAN
- B. PURGE
- C. REMOVE
- D. DELETE
Answer: C
NEW QUESTION # 61
Which of the two are limitations of the insertReport API of SnowPipe?
- A. Events are retained for a maximum of 24 hours
- B. Events are retained for a maximum of 10 minutes
- C. The 10,000 most recent events are retained
Answer: B,C
NEW QUESTION # 62
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 # 63
Materialized views based on external tables can improve query performance
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 64
An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user's role must have which privileges? (Choose two.)
- A. IMPORT DATABASE;
- B. CREATE DATABASE;
- C. CREATE SHARE;
- D. IMPORT SHARE;
- E. IMPORT PRIVILEGES;
Answer: B,E
NEW QUESTION # 65
What are purposes for creating a storage integration? (Choose three.)
- A. Support multiple external stages using one single Snowflake object.
- B. Manage credentials from multiple cloud providers in one single Snowflake object.
- C. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
- D. Avoid supplying credentials when creating a stage or when loading or unloading data.
- E. Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
- F. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider's key management service.
Answer: A,C,D
NEW QUESTION # 66
......
Reliable Study Materials for ARA-C01 Exam Success For Sure: https://www.pass4leader.com/Snowflake/ARA-C01-exam.html
Get Unlimited Access to ARA-C01 Certification Exam Cert Guide: https://drive.google.com/open?id=1CN8hFQiHS0seKpQBh8nsmw2jC-TrGO9d