Free SnowPro Advanced Architect Exam braindumps download (SnowPro Advanced Architect exam dumps Free)

QUESTION: 41

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 group's 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?

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.
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.
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.
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(s): D

Show Answer Next Question

QUESTION: 42

A company's daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.

What configuration can the company's Architect implement to enhance the performance of this workload? (Choose two.)

Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
Increase the size of the virtual warehouse to size X-Large.
Reduce the amount of data that is being processed through this workload.
Set the connection timeout to a higher value than its default.

Answer(s): A,C

Show Answer Next Question

QUESTION: 43

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

SYSTEM$CLUSTERING_INFORMATION
SYSTEM$CLUSTERING_USAGE
SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_KEYS
SYSTEM$CLUSTERING_PERCENT

Answer(s): A,C

Show Answer Next Question

QUESTION: 44

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?

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

Answer(s): C

Show Answer Next Question

QUESTION: 45

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.

Which actions can the company take with the inbound share? (Choose two.)

Clone a table from a share.
Grant modify permissions on the share.
Create a table from the shared database.
Create additional views inside the shared database.
Create a table stream on the shared table.

Answer(s): C,E

Show Answer Next Question

Free SnowPro Advanced Architect Exam Braindumps SnowPro Advanced Architect Questions 41–45 (page: 10)

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44

QUESTION: 45

Free SnowPro Advanced Architect Exam Braindumps
SnowPro Advanced Architect Questions 41–45 (page: 10)