Give Push to your Success with SnowPro Core SnowPro-Core Exam Questions [Q274-Q297] : Latest Exam Prep : http://certify.vceprep.com

NO.274 In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

NO.275 What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Duo Security

OAuth

Okta

Single Sign-On (SSO)

NO.276 What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

NO.277 Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Materialized View

Pipe

Stream

Task

NO.278 True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True

False

NO.279 Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

USAGE

OPERATE

MONITOR

MODIFY

NO.280 What is the purpose of a Query Profile?

To profile how many times a particular query was executed and analyze its u^age statistics over time.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

NO.281 What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.

Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.

Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days.

NO.282 The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

NO.283 True or False: Snowpipe via RFST API can only reference External Stages as source.

True

False

NO.284 Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

NO.285 Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?

Scale up the existing warehouse.

Create separate warehouses for each user.

Create separate warehouses for each workload.

Stop loading and querying data at the same time.

NO.286 Which Snowflake table objects can be shared with other accounts? (Select TWO).

Temporary tables

Permanent tables

Transient tables

External tables

User-Defined Table Functions (UDTFs)

NO.287 Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

UPDATE TABLE FROM STREAM

SELECT FROM STREAM

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

BEGIN COMMIT

NO.288 A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

NO.289 The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

NO.290 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?

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

NO.291 If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.

The Warehouse is inactive for a specified period of time.

NO.292 Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

NO.293 Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

NO.294 What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Swift

JavaScript

Python

SQL

NO.295 True or False: Fail-safe can be disabled within a Snowflake account.

True

False

NO.296 Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

NO.297 Which of the following terms best describes Snowflake’s database architecture?

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory