Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

SnowPro-Core PDF

$38.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

SnowPro-Core PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

  • Exam Name: SnowPro Core Certification Exam
  • Last Update: Apr 23, 2024
  • Questions and Answers: 427
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

SnowPro-Core Engine

$46.2

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

SnowPro-Core Practice Exam Questions with Answers SnowPro Core Certification Exam Certification

Question # 6

What type of function returns one value for each Invocation?

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Full Access
Question # 7

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

A.

Binary file in Avro

B.

Binary file in Parquet

C.

Comma-separated JSON

D.

Newline Delimited JSON

E.

Plain text file containing XML elements

Full Access
Question # 8

Which statement accurately describes Snowflake's architecture?

A.

It uses a local data repository for all compute nodes in the platform.

B.

It is a blend of shared-disk and shared-everything database architectures.

C.

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

D.

It reorganizes loaded data into internal optimized, compressed, and row-based format.

Full Access
Question # 9

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

A.

Clone the data from the production account to the non-production account.

B.

Create a data share from the production account to the non-production account.

C.

Create a subscription in the production account and have it publish to the non-production account.

D.

Create a reader account using the production account and link the reader account to the non-production account.

Full Access
Question # 10

Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Full Access
Question # 11

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

A.

1 minutes

B.

5 minutes

C.

10 minutes

D.

15 minutes

Full Access
Question # 12

Which URL provides access to files in Snowflake without authorization?

A.

File URL

B.

Scoped URL

C.

Pre-signed URL

D.

Scoped file URL

Full Access
Question # 13

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Full Access
Question # 14

What are characteristics of reader accounts in Snowflake? (Select TWO).

A.

Reader account users cannot add new data to the account.

B.

Reader account users can share data to other reader accounts.

C.

A single reader account can consume data from multiple provider accounts.

D.

Data consumers are responsible for reader account setup and data usage costs.

E.

Reader accounts enable data consumers to access and query data shared by the provider.

Full Access
Question # 15

What does the TableScan operator represent in the Query Profile?

A.

The access to a single table

B.

The access to data stored in stage objects

C.

The list of values provided with the VALUES clause

D.

The records generated using the TABLE (GENERATOR (...)) construct

Full Access
Question # 16

How can a user get the MOST detailed information about individual table storage details in Snowflake?

A.

SHOW TABLES command

B.

SHOW EXTERNAL TABLES command

C.

TABLES view

D.

TABLE STORAGE METRICS view

Full Access
Question # 17

What are characteristics of transient tables in Snowflake? (Select TWO).

A.

Transient tables have a Fail-safe period of 7 days.

B.

Transient tables can be cloned to permanent tables.

C.

Transient tables persist until they are explicitly dropped.

D.

Transient tables can be altered to make them permanent tables.

E.

Transient tables have Time Travel retention periods of 0 or 1 day.

Full Access
Question # 18

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Full Access
Question # 19

Which role has the ability to create a share from a shared database by default?

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Full Access
Question # 20

What is the MINIMUM permission needed to access a file URL from an external stage?

A.

MODIFY

B.

READ

C.

SELECT

D.

USAGE

Full Access
Question # 21

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.

How will those object names be resolved during execution?

A.

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.

Snowflake will only check the schema the UDF belongs to.

C.

Snowflake will first check the current schema, and then the schema the previous query used

D.

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Full Access
Question # 22

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Full Access
Question # 23

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

A.

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Full Access
Question # 24

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

A.

Use the SHOW STAGES command.

B.

Use the DESCRIBE STAGE command.

C.

Use the GET_ABSOLUTE_PATH function.

D.

Use the GET_STAGE_LOCATION function.

Full Access
Question # 25

How are network policies defined in Snowflake?

A.

They are a set of rules that define the network routes within Snowflake.

B.

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect

to Snowflake.

Full Access
Question # 26

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

A.

ARRAY

B.

OBJECT

C.

TEXT

D.

VARIANT

Full Access
Question # 27

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

A.

1

B.

5

C.

10

D.

100

Full Access
Question # 28

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Full Access
Question # 29

Which of the following describes external functions in Snowflake?

A.

They are a type of User-defined Function (UDF).

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Full Access
Question # 30

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

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Full Access
Question # 31

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

A.

The table contains a column that has very low cardinality

B.

DML statements that are being issued against the table are blocked

C.

The table has a small number of micro-partitions

D.

Queries on the table are running slower than expected

E.

The clustering depth for the table is large

Full Access
Question # 32

Which cache type is used to cache data output from SQL queries?

A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Full Access
Question # 33

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

A.

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

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Full Access
Question # 34

Which feature is only available in the Enterprise or higher editions of Snowflake?

A.

Column-level security

B.

SOC 2 type II certification

C.

Multi-factor Authentication (MFA)

D.

Object-level access control

Full Access
Question # 35

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Full Access
Question # 36

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A.

Informatica

B.

Power Bl

C.

Adobe

D.

Data Robot

Full Access
Question # 37

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

A.

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

B.

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

C.

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

D.

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

E.

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

Full Access
Question # 38

Which command is used to unload data from a Snowflake table into a file in a stage?

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Full Access
Question # 39

What is the MOST performant file format for loading data in Snowflake?

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Full Access
Question # 40

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A.

Pipes

B.

Streams

C.

Tasks

D.

Procedures

Full Access
Question # 41

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

Full Access
Question # 42

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

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Full Access
Question # 43

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Full Access
Question # 44

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A.

True

B.

False

Full Access
Question # 45

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

A.

The ability to scale up warehouses

B.

The use of warehouse auto scaling

C.

The ability to resize warehouses

D.

Use of multi-clustered warehouses

E.

The use of warehouse indexing

Full Access
Question # 46

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A.

The user has the appropriate privileges on the objects associated with the query

B.

Micro-partitions have been reclustered since the query was last run

C.

The new query is run using the same virtual warehouse as the previous query

D.

The query includes a User Defined Function (UDF)

E.

The query has been run within 24 hours of the previously-run query

Full Access
Question # 47

Will data cached in a warehouse be lost when the warehouse is resized?

A.

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.

No. because the size of the cache is independent from the warehouse size

D.

Yes. became the new compute resource will no longer have access to the cache encryption key

Full Access
Question # 48

Which of the following can be executed/called with Snowpipe?

A.

A User Defined Function (UDF)

B.

A stored procedure

C.

A single copy_into statement

D.

A single insert__into statement

Full Access