Question 1

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 2

How many files can the COPY INTO operation load as the maximum when providing a discrete list of files?

Options :

A : 10000

B : There is no limit.

C : 1000

D : 100

Answer: C

Question 3

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 :

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

B :

C :

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

You have created a table as below

CREATE TABLE SNOWFLAKE (TEST_ID INTEGER, TEST_COURSE VARCHAR);

Which of the below select query will fail for this table?

Options :

A : SELECT * from snowflake;

B : SELECT * from 'snowflake';

C : SELECT * FROM 'SNOWFLAKE';

Answer: B