QUESTION: 17

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Shared databases are read-only.
Shared databases must be refreshed in order for new data to be visible.
Shared databases cannot be cloned.
Shared databases are not supported by Time Travel.
Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
Shared databases can also be created as transient databases.

Answer(s): A,C,E

Reveal Solution Next Question

QUESTION: 18

What integration object should be used to place restrictions on where data may be exported?

Stage integration
Security integration
Storage integration
API integration

Answer(s): C

Reveal Solution Next Question

QUESTION: 19

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

The warehouse MY_WH will be made active every five minutes to check the stream.
The warehouse MY_WH will only be active when there are results in the stream.
The warehouse MY_WH will never suspend.
The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer(s): A

Reveal Solution Next Question

QUESTION: 20

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

The Connector only works in Snowflake regions that use AWS infrastructure.
The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
The Connector creates and manages its own stage, file format, and pipe objects.
Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer(s): C

Reveal Solution Next Question

Free SnowPro Advanced Architect Exam Braindumps (page: 6)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

SnowPro Advanced Architect Discussions & Posts