Question 1

Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only

Options :

A : TRUE

B : FALSE

Answer: A

Question 2

The insertReport endpoint can be thought of like the UNIX command tail

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What command will accomplish this?

Options :

A : CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

B : CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

C : CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

D : CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Answer: C

Question 4

A Snowflake Architect is designing a multiple-account design strategy. This strategy will be MOST cost-effective with which scenarios? (Select TWO).

Options :

A : The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

B : The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

C : The company needs to support different role-based access control features for the development, test, and production environments.

D : The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

E : The company must use a specific network policy for certain users to allow and block given IP addresses.

Answer: B,D

Question 5

You have an inventory table. You created two views on this table. The views look like as belowCREATE VIEW NON_SECURE_INVENTORY ASSELECT BIBNUMBER, TITLE, AUTHOR,ISBNFROM INVENTORYWHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);CREATE SECURE VIEW SECURE_INVENTORY ASSELECT BIBNUMBER, TITLE, AUTHOR,ISBNFROM INVENTORYWHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);You ran the below queriesALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cacheSELECT * 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 belowBoth 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

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: