[Sep 10, 2023] Get to the Top with SnowPro-Core Practice Exam Questions [Q103-Q124]

5/5 - (1 vote)

[Sep 10, 2023] Get to the Top with SnowPro-Core Practice Exam Questions

Use Real SnowPro-Core Dumps Free Sample Questions and Practice Test Engine

The SnowPro-Core certification is designed for data professionals, architects, and engineers who work with Snowflake. SnowPro Core Certification Exam certification exam validates the skills required to design, build, and manage data solutions on the Snowflake platform. The SnowPro-Core certificate is a testament to a candidate’s expertise in Snowflake and is recognized worldwide.

QUESTION 103
What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

QUESTION 104
Which stream type can be used for tracking the records in external tables?

Append-only

External

Insert-only

Standard

QUESTION 105
The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

QUESTION 106
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python
D18912E1457D5D1DDCBD40AB3BF70D5D

QUESTION 107
Using variables in Snowflake is denoted by using which SQL character?

QUESTION 108
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period

The same exact query will return the precomputed results if the underlying data hasn’t changed and the results were last accessed within previous 24 hour period

The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period

The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed

QUESTION 109
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

COPY INTO

CREATE PIPE

INSERT INTO

TABLE STREAM

QUESTION 110
How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely

Until the result_cache expires

Until the retention_time is met

Until the expiration time is exceeded

QUESTION 111
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

QUESTION 112
Which parameter prevents streams on tables from becoming stale?

MAXDATAEXTENSIONTIMEINDAYS

LOCK_TIMEOUT

STALE_AFTER

MTN_DATA_RETENTION_TTME_TN_DAYS

QUESTION 113
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer

Compute

Tri-Secret Secure

Storage

Cloud Services

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

QUESTION 114
Select the three types of tables that exist within Snowflake.
Choose 3 answers

Temporary

Transient

Provisioned

Permanent

Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

QUESTION 115
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

QUESTION 116
By default, which Snowflake role is required to create a share?

ORGADMIN

SECURITYADMIN

SHAREADMIN

ACCOUNTADMIN

QUESTION 117
Which of the following are options when creating a Virtual Warehouse?

Auto-suspend

Auto-resume

Local SSD size

User count

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

An FTP server with TLS encryption

An HTTPS server with WebDAV

A Google Cloud storage bucket

A Windows server file share on Azure

QUESTION 119
Where can a user find and review the failed logins of a specific user for the past 30 days?

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

QUESTION 120
True or False: Fail-safe can be disabled within a Snowflake account.

True

False

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

QUESTION 121
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Use the DROP <file> command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO <table> command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

QUESTION 122
A materialized view should be created when which of the following occurs? (Choose two.)

There is minimal cost associated with running the query.

The query consumes many compute resources every time it runs.

The base table gets updated frequently.

The query is highly optimized and does not consume many compute resources.

The results of the query do not change often and are used frequently.

QUESTION 123
How would a user run a multi-cluster warehouse in maximized mode?

Configure the maximum clusters setting to “Maximum.”

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

QUESTION 124
Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema – > ACCOUNT_USAGE_METRICS View

Loading …

Pass Snowflake SnowPro-Core exam – questions – convert Tets Engine to PDF: https://www.troytecdumps.com/SnowPro-Core-troytec-exam-dumps.html

High-quality Troytec review files

[Sep 10, 2023] Get to the Top with SnowPro-Core Practice Exam Questions [Q103-Q124]

troytecdumps

Leave a Reply Cancel reply

Related Posts

Latest Snowflake DAA-C01 PDF and Dumps (2026) Free Exam Questions Answers [Q15-Q36]

[Oct 08, 2025] Free Snowflake ARA-C01 Exam Questions & Answer [Q29-Q45]

[Q18-Q35] Full ARA-C01 Practice Test and 162 unique questions with explanations waiting just for you!

troytecdumps

Leave a Reply Cancel reply