QUESTION: 153

What is a key feature of Snowflake architecture?

Zero-copy cloning creates a mirror copy of a database that updates with the original.
Software updates are automatically applied on a quarterly basis.
Snowflake eliminates resource contention with its virtual warehouse implementation.
Multi-cluster warehouses allow users to run a query that spans across multiple clusters.
Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date.

Answer(s): C

QUESTION: 154

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

There is no need to have a Snowflake account in the target region, a share will be created for each user.
The listing is replicated into all selected regions automatically, the data is not.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
Shares attached to listings in remote regions can be viewed from any account in an organization.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 155

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB
100-250 MB
300-500 MB
1000-1500 MB

Answer(s): B

Reveal Solution Next Question

QUESTION: 156

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tokenization
External Tables
Materialized Views
User-Defined Table Functions (UDTF)

Answer(s): A

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 40)

QUESTION: 153

QUESTION: 154

QUESTION: 155

QUESTION: 156

SnowPro Core Exam Discussions & Posts