2023 Updated Verified Pass SnowPro-Core Exam – Real Questions & Answers [Q78-Q102]

4/5 - (2 votes)

2023 Updated Verified Pass SnowPro-Core Exam – Real Questions and Answers

Dumps Moneyack Guarantee – SnowPro-Core Dumps Approved Dumps

To prepare for the SnowPro Core Certification Exam, candidates can take advantage of a range of resources, including online training courses, practice exams, and study guides. These resources are designed to help candidates gain a deep understanding of Snowflake’s core services and features and develop the skills needed to pass the exam.

NO.78 A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Compress the file and load the compressed file.

Split the file into multiple files in the recommended size range (100 MB – 250 MB).

Use a larger-sized warehouse.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

NO.79 What is the most granular object that the Time Travel retention period can be defined on?
Select one.

Account

Database

Schema

Table

NO.80 Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

NO.81 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

NO.82 Which user object property requires contacting Snowflake Support in order to set a value for it?

DISABLED

MINS TO BYPASS MFA

MINS TO BYPASS NETWORK POLICY

MINS TO UNLOCK

NO.83 Which activities are included in the Cloud Sen/ices layer? (Select TWO).

Data storage

Dynamic data masking

Partition scanning

User authentication

Infrastructure management

NO.84 Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

SHOW TABLES;

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TASLE_HISTORY

NO.85 Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

ORC

XML

Avro

Parquet

JSON

NO.86 True or False: Snowflake charges additional fees to Data providers for each share they create.

True

False

NO.87 Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

NO.88 The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

NO.89 Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

More micro-partitions

Better query scheduling

Double the numbers of servers In the compute duster

Higher storage costs

NO.90 What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

NO.91 Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Materialized view

Sequence

Secure view

Transient table

Clustered table

NO.92 Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Bytes sent over network

Percentage scanned from cache

Partitions total

Bytes spilled to local storage

Partitions scanned

NO.93 True or False: During data unloading, only JSON and CSV files can be compressed.

True

False

NO.94 In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

NO.95 In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Services Layer

NO.96 What command is used to load files into an Internal Stage within Snowflake? Select one.

PUT

COPY INTO

TRANSFER

INSERT

NO.97 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

NO.98 How long is Snowpipe data load history retained?

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

NO.99 What privileges are required to create a task?

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

NO.100 Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Data is live, ready-to-query, and can be personalized.

Data needs to be loaded into a cloud provider as a consumer account.

Data is not available for copying or moving to an individual Snowflake account.

Data is available without copying or moving.

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

NO.101 What features does Snowflake Time Travel enable?

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

NO.102 What is true about sharing data in Snowflake? (Choose two.)

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Updated PDF (New 2023) Actual Snowflake SnowPro-Core Exam Questions: https://www.test4cram.com/SnowPro-Core_real-exam-dumps.html

Leave a Reply Cancel reply