Question 1

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The groups manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

Options :

A :

Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

B :

Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

C :

Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

D :

This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

Answer: C

Question 2

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

Options :

A :

GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

B : GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

C :

GRANT ROLE NEW_ROLE TO USER USER_01; GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

D :

GRANT ROLE NEW_ROLE TO USER_01; GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Answer: A

Question 3

You have create a task as below

CREATE TASK mytask1

WAREHOUSE = mywh

SCHEDULE = '5 minute'

WHEN

SYSTEM$STREAM_HAS_DATA('MYSTREAM')

AS

INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';

Which statement is true below?

Options :

A : If SYSTEM$STREAM_HAS_DATA returns false, the task will be skipped

B : If SYSTEM$STREAM_HAS_DATA returns false, the task will still run

C : If SYSTEM$STREAM_HAS_DATA returns false, the task will go to suspended mode

Answer: A

Question 4

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

Options :

A : CSV

B : XML

C : Avro

D : JSON

E : Parquet

Answer: C,D

Question 5

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

Options :

A : The Connector only works in Snowflake regions that use AWS infrastructure.

B : The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.

C : The Connector creates and manages its own stage, file format, and pipe objects.

D : Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer: C

Confidently Practice Online with Free SnowPro-Advanced-Architect Exam Cram

Buying Options: