Snowflake SnowPro-Core Exam Actual Questions

Name: SnowPro Core Certification Exam
Brand: QA4Exam
SKU: SnowPro-Core
Price: 30 USD
Availability: InStock
Rating: 4.8 (400 reviews)

The questions for SnowPro-Core were last updated on Oct 1, 2024.

Viewing page 1 out of 85 pages.
Viewing questions 1-5 out of 427 questions

Unlock Access to All 427 Questions & Answers

Question No. 1

Which object can be used with Secure Data Sharing?

AView

BMaterialized view

CExternal table

DUser-Defined Function (UDF)

Show Answer

Correct Answer: A

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

Question No. 2

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

AReview the granted privileges to the database object.

BReview the row access policy for the database object.

CQuery the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

DQuery the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

Show Answer

Correct Answer: C

To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query theACCESS_HISTORYview in theACCOUNT_USAGEschema, which provides information about access to database objects3.

Question No. 3

Which type of loop requires a BREAK statement to stop executing?

AFOR

BLOOP

CREPEAT

DWHILE

Show Answer

Correct Answer: B

TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.

Question No. 4

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

AColumn compression

BData clustering

CMicro-partitioning

DMetadata management

Show Answer

Correct Answer: C

Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning.It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.

Question No. 5

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

AACCESS_HISTORY

BDATA_TRANSFER_HISTORY

CWAREHOUSE_METERING_HISTORY

DMONETIZED_USAGE_DAILY

ELISTING TELEMETRY DAILY

Show Answer

Correct Answer: D, E

The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

Unlock All Questions for Snowflake SnowPro-Core Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 427 Questions & Answers