Question 1

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)');

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

Options :

A : 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

B : The query is running slow because the warehouse does not have enough memory

C : The query is running slow because BIBNUMBER does not have an index created on it.

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

An Architect entered the following commands in sequence:

USER1 cannot find the table. Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

Options :

A : GRANT ROLE PUBLIC TO ROLE INTERN;

B : GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

C : GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

D : GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

E : GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

Answer: B,C

Question 4

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.)

Options :

A : Set up replication to allow users to connect from outside the company VPN.

B : Provision a unique company Tri-Secret Secure key.

C : Use private connectivity from a cloud provider.

D : Set up SSO for federated authentication.

E : Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Answer: C,D

Question 5

When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Options :

A : 8 hours

B : 4 hours

C : 2 hours

D : 1 hour

Answer: B

Higher Test Marks with Free Online SnowPro-Advanced-Architect Exam Practice

Buying Options: