[Jul-2024] SnowPro Core SnowPro-Core Exam Practice Dumps [Q11-Q34]

Rate this post

[Jul-2024] SnowPro Core SnowPro-Core Exam Practice Dumps

2024 SnowPro-Core Premium Files Test pdf – Free Dumps Collection

Q11. True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True

False

Q12. Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

PURGE

MODIFY

REMOVE

DELETE

Q13. What is the MAXIMUM size limit for a record of a VARIANT data type?

8MB

16MB

32MB

128MB

Q14. Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

FLATTEN

OBJECT_AS

OBJECT_CONSTRUCT

TO VARIANT

Q15. A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

Create a zero-copy clone of the worksheet and grant permissions to teammates

Create a private Data Exchange so that any teammate can use the worksheet

Share the worksheet with teammates within Snowsight

Create a database and grant all permissions to teammates

Q16. Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

Q17. What internal stages are available in Snowflake? (Choose three.)

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

Q18. Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

Q19. Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

Q20. Which of the following statements about data sharing are true?
choose 2 answers

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

Q21. The VALIDATE table function has which parameter as an input argument for a Snowflake user?

Last_QUERY_ID

CURRENT_STATEMENT

UUID_STRING

JOB_ID

Q22. Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

A Data Exchange allows groups of accounts to share data privately among the accounts.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Q23. Which of the following statements is true of zero-copy cloning?

Zero-copy clones increase storage costs as cloning the table requires storing its data twice

All zero-copy clone objects inherit the privileges of their original objects

Zero-copy cloning is licensed as an additional Snowflake feature

At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Q24. What privileges are required to execute a task?

To execute a task, you need the EXECUTE TASK.

A task is an account-level object and can only be executed by the Account Admin role.

Tasks run automatically and do run under any rote.

Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

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

True

False

Q26. Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

Q27. 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

Q28. How can a user improve the performance of a single large complex query in Snowflake?

Scale up the virtual warehouse.

Scale out the virtual warehouse.

Enable standard warehouse scaling.

Enable economy warehouse scaling.

Q29. Which REST API can be used with unstructured data?

inscrtFilcs

insertReport

GET /api/tiles/

loadHistoryScan

Q30. How does the Access_History view enhance overall data governance pertaining to read and write operations?
(Select TWO).

Shows how the accessed data was moved from the source lo the target objects

Provides a unified picture of what data was accessed and when it was accessed

Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime

Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Q31. Which stage type can be altered and dropped?

Database stage

External stage

Table stage

User stage

Q32. What is the MAXIMUM Time Travel retention period for a transient table?

O days

1 day

7 days

90 days

Q33. A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

The exact query win ALWAYS return me 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 the 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

The ”24 hour” on the percomputed results gets renewed every time the exact query is executed

Q34. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

The SnowPro Core Certification exam is a comprehensive test that covers a wide range of topics related to Snowflake. It is designed for individuals who work with Snowflake on a daily basis, such as data engineers, data analysts, and database administrators. SnowPro-Core exam consists of 70 multiple-choice questions and is timed at 90 minutes. It covers topics such as Snowflake architecture, data loading and unloading, data modeling, and security.

Get ready to pass the SnowPro-Core Exam right now using our SnowPro Core Exam Package: https://www.test4cram.com/SnowPro-Core_real-exam-dumps.html

Leave a Reply Cancel reply