Question 1

One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue?

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

Options :

A : This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in a cartesian product

B : There is not enough memory to process the join query

C : Looks like tablescan is the most expensive operation in the profile.

Answer: A

Question 2

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

Options :

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: C

Question 3

What is the function of Resource Monitors regarding data pipelines?

Options :

A : Make data not being replicated twice in the same pipeline

B : It performs backups for your pipelines every 5 minutes

C : It helps you monitor and control the costs of your pipelines

Answer: C

Question 4

While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose to setup the access?

Options :

A :

B :

C :

Answer: C

Confidently Practice Online with Free ARA-C01 Exam Cram

Buying Options: