Question 1

You have an inventory table. You created two views on this table. The views look like as below

CREATE VIEW NON_SECURE_INVENTORY AS

SELECT BIBNUMBER, TITLE, AUTHOR,ISBN

FROM INVENTORY

WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);

CREATE SECURE VIEW SECURE_INVENTORY AS

SELECT BIBNUMBER, TITLE, AUTHOR,ISBN

FROM INVENTORY

WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);

You ran the below queries

ALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cache

SELECT * FROM NON_SECURE_INVENTORY WHERE BIBNUMBER =511784;

SELECT * FROM SECURE_INVENTORY WHERE BIBNUMBER =511784;

The query profile for the first query looks as below

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

However, the query profile for the second one looks like as below

Both the views use the same columns from the same underlying view. So, why is this difference in query profiles.

Options :

A : Secure views do not expose the underlying tables or internal structural details for a view

B : The query profile is corrupted

C : The query is run by a role that did not have access to the view

Answer: A

Question 2

What are characteristics of Dynamic Data Masking? (Select TWO).

Options :

A : A masking policy that Is currently set on a table can be dropped.

B : A single masking policy can be applied to columns in different tables.

C : A masking policy can be applied to the value column of an external table.

D : The role that creates the masking policy will always see unmasked data In query results

E : A masking policy can be applied to a column with the GEOGRAPHY data type.

Answer: A,B

Question 3

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

Options :

A :

Connect the applications using the - URL. Use the Business Critical Snowflake edition.

B : Connect the applications using the - URL. Use the Virtual

Private Snowflake (VPS) edition.

C :

Connect the applications using the - URL. Use the Enterprise Snowflake edition.

D :

Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Answer: D

Question 4

External functions must be scalar functions

Options :

A : TRUE

B :

FALSE

Answer: A

Question 5

You have written a procedure and a function in snowflake. How do you find your procedures and functions in snowflake?

Options :

A :

SHOW PROCEDURES;

SHOW FUNCTIONS;

B : SHOW ALL PROCEDURES AND FUNCTIONS

C : SHOW PROCEDURES, FUNCTIONS

Answer: A