Question 1

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 2

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data. How should these requirements be met?

Options :

A :

Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B :

Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

C :

Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.

D :

Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

Answer: C

Question 3

You have created a table as below

CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR);

What datatype Snowflake will use for EMPLOYEE_ID?

Options :

A : FIXED

B : INTEGER

C : NUMBER

Answer: A

Question 4

You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?

Options :

A : Set PURGE=TRUE in the COPY INTO command

B : Set REMOVE=TRUE in the COPY INTO Command

C : No need to do anything, snowflake does it automatically

Answer: A

Question 5

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