What is a key feature of Snowflake architecture?

Snowflake eliminates resource contention with its virtual warehouse implementation

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

What is a limitation of a Materialized View?

A Materialized View cannot be defined with a JOIN

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

What features does Snowflake Time Travel enable?

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

Which statement about billing applies to Snowflake credits?

Credits are consumed based on the warehouse size and the time the warehouse is running

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

The use of warehouse auto scaling

Use of multi-clustered warehouses

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered warehouses

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Automatic encryption of all data

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Column-level security to apply data masking policies to tables and views

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.What would be the MOST efficient way to get the files into Snowflake?

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:COPY INTO my__table FROM @my__stage;The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.If the user runs the same copy into command what will happen?

All data from all of the files on the stage will be appended to the table

Only data about new customers from the new files will be appended to the table

The operation will fail with the error uncertain files in stage.

All data from only the newly-added files will be appended to the table.

What happens when a cloned table is replicated to a secondary database? (Select TWO)

The physical data is replicated

Metadata pointers to cloned tables are replicated

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Each Snowflake account can be hosted in a different cloud vendor and region.

Each Snowflake account must be hosted in a different cloud vendor and region

All Snowflake accounts must be hosted in the same cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Where would a Snowflake user find information about query activity from 90 days ago?

account__usage.query__history__archive View

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema - query history_by_ses s i on view

What happens when an external or an internal stage is dropped? (Select TWO).

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an external stage, both the stage and the files within the stage are removed

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

How long is Snowpipe data load history retained?

As configured in the create pipe settings

In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.Which of the following statements will accommodate this request?

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

The query is spilling to remote storage

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Which command can be used to stage local files from which Snowflake interface?

Snowflake classic web interface (Ul)

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Allows optimization of parallel operations

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

Allows a user to import the files in a sequential order

Increases the latency staging and accuracy when loading the data

Allows optimization of parallel operations

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Database replication and failover

Customer managed keys (Tri-secret secure)

Native support for geospatial data

Snowflake SnowPro Core Practice Test 2 - Free Online Exam Prep & Questions

Question 1 / 40

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

Comment (0)

Snowflake SnowPro Core Practice Test 2

Question

Snowflake SnowPro Core Practice Tests

Practice Tests