QUESTION: 21

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.
By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
Contact Snowflake and they will execute the share request for the healthcare company.
Set the share_restriction parameter on the shared object to false.

Answer(s): C

Reveal Solution Next Question

QUESTION: 22

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner.
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

Utilize a higher Buffer.flush.time in the connector configuration.
Utilize a higher Buffer.size.bytes in the connector configuration.
Utilize a lower Buffer.size.bytes in the connector configuration.
Utilize a lower Buffer.count.records in the connector configuration.

Answer(s): D

Reveal Solution Next Question

QUESTION: 23

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.

The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.
Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?

1) Create a share in the Production account for each database
2) Share access to the QA account as a Consumer
3) The QA account creates a database directly from each share
4) Create clones of those databases on a nightly basis
5) Run tests directly on those cloned databases
1) Create a stage in the Production account
2) Create a stage in the QA account that points to the same external object-storage location 3) Create a task that runs nightly to unload each table in the Production account into the stage 4) Use Snowpipe to populate the QA account
1) Enable replication for each database in the Production account
2) Create replica databases in the QA account
3) Create clones of the replica databases on a nightly basis
4) Run tests directly on those cloned databases
1) In the Production account, create an external function that connects into the QA account and returns all the data for one specific table 2) Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account

Answer(s): A

Reveal Solution Next Question

QUESTION: 24

A user can change object parameters using which of the following roles?

ACCOUNTADMIN, SECURITYADMIN
SYSADMIN, SECURITYADMIN
ACCOUNTADMIN, USER with PRIVILEGE
SECURITYADMIN, USER with PRIVILEGE

Answer(s): A

Reveal Solution Next Question

Free SnowPro Advanced Architect Exam Braindumps (page: 6)

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24