Dec-2023 New Version ARA-C01 Certificate & Helpful Exam Dumps is Online
ARA-C01 Free Certification Exam Material with 217 Q&As
NEW QUESTION # 97
Schema owner can grant object privileges in a regular schema
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION # 98
Which command below will only copy the table structure from the existing table to the new table?
- A. CREATE TABLE ... CLONE
- B. CREATE TABLE ... LIKE
- C. CREATE TABLE ... AS SELECT
Answer: B
NEW QUESTION # 99
Which of the following are characteristics of Snowflake's parameter hierarchy?
- A. Schema parameters override account parameters.
- B. Virtual warehouse parameters override user parameters.
- C. Session parameters override virtual warehouse parameters.
- D. Table parameters override virtual warehouse parameters.
Answer: C
NEW QUESTION # 100
The insertReport endpoint can be thought of like the UNIX command tail
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 101
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.size.bytes in the connector configuration.
- B. Utilize a higher Buffer.flush.time in the connector configuration.
- C. Utilize a lower Buffer.size.bytes in the connector configuration.
- D. Utilize a lower Buffer.count.records in the connector configuration.
Answer: D
NEW QUESTION # 102
You have created a TASK in snowflake.
How will you resume it?
- A. No need to resume, the creation operation automatically enables the task
- B. ALTER TASK mytask1 RESUME;
- C. ALTER TASK mytask1 START;
Answer: B
NEW QUESTION # 103
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, USAGE on all schemas in database hr_db, REFERENCES 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, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
Answer: C
NEW QUESTION # 104
How do you validate the data that is unloaded using COPY INTO command
- A. Use validation_mode='RETURN_ROWS'; with COPY command
- B. After unloading, load the data into a relational table and validate the rows
- C. Load the data into a CSV file to validate the rows
Answer: A
NEW QUESTION # 105
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below
{
"COURSE_DESC": "SNOWFLAKE CERTIFICATION",
"COURSE_ID": 1000,
"DURATION": 2
}
if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it return
- A. 0
- B. 1
- C. NULL
Answer: C
NEW QUESTION # 106
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 local disk cache
- C. The percentage of data scanned from the QUERY cache
Answer: B
NEW QUESTION # 107
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. PERMANENT
- B. TRANSIENT
- C. TEMPORARY
Answer: B
NEW QUESTION # 108
Snowflake supports the following query performance optimizing methods
- A. Retrieving results of previous query from cache
- B. Caching techniques
- C. B-tree type indexes
Answer: A,B
NEW QUESTION # 109
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 # 110
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?
- A. Only if the system estimates there's enough query load to keep the cluster busy for at least 4 minutes.
- B. Immediately when either a query is queued or the system detects that there's one more query than the currently-running clusters can execute
- C. Only if the system estimates there's enough query load to keep the cluster busy for at least 6 minutes.
Answer: B
NEW QUESTION # 111
What will the below query return
SELECT TOP 10 GRADES FROM STUDENT;
- A. The 10 lowest grades
- B. Non-deterministic list of 10 grades
- C. The top 10 highest grades
Answer: B
NEW QUESTION # 112
It is recommended to assign ACCOUNTADMIN role to atleast two user
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 113
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. IMPORT SHARE
- B. IMPORTED PRIVILEGES
- C. SHARED PRIVILEGES
Answer: B
NEW QUESTION # 114
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.
How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)
- A. Use Snowpipe with auto-ingest.
- B. Use a COPY command with a task.
- C. Use the COPY INTO command.
- D. Use a materialized view on an external table.
- E. Use a combination of a task and a stream.
Answer: A,E
NEW QUESTION # 115
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
- A. Extended Time Travel (up to 90 days)
- B. AWS, Azure, or Google Cloud private connectivity to Snowflake
- C. Federated authentication and SSO
- D. Periodic rekeying of encrypted data
- E. Customer-managed encryption keys through Tri-Secret Secure
Answer: B,E
NEW QUESTION # 116
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 117
What are purposes for creating a storage integration? (Choose three.)
- A. Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
- B. Avoid supplying credentials when creating a stage or when loading or unloading data.
- C. Manage credentials from multiple cloud providers in one single Snowflake object.
- D. Support multiple external stages using one single Snowflake object.
- E. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider's key management service.
- F. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
Answer: B,D,F
NEW QUESTION # 118
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 BIBNUMBER does not have an index created on it.
- B. The query is running slow because the warehouse does not have enough memory
- C. 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
Answer: C
NEW QUESTION # 119
Select the true statement
- A. Privileges are granted to roles. Roles are granted to users
- B. Privileges are granted to both roles and users
- C. Privileges are granted to users. Users are granted to roles
Answer: A
NEW QUESTION # 120
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 121
Refreshing a secondary database is not allowed in the following circumstances
- A. Materialized views
- B. Primary database contains transient tables
- C. Primary database has external table
- D. Databases created from shares
Answer: C,D
NEW QUESTION # 122
......
Get The Important Preparation Guide With ARA-C01 Dumps: https://www.itexamdownload.com/ARA-C01-valid-questions.html
UPDATED ARA-C01 Exam Questions Certification Test Engine to PDF: https://drive.google.com/open?id=1Vkg5Ynv_TZdYP37TzO0LnzE-y29PbbGL