Leading SnowPro-Core Free Samples For SnowPro Core Certification Exam Certification

NEW QUESTION 1

True or False: Once created, a micro-partition will never be changed.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

NEW QUESTION 2

Which of the following describes the Snowflake Cloud Services layer?

• A. Coordinates activities in the Snowflake account
• B. Executes queries submitted by the Snowflake account users
• C. Manages quotas on the Snowflake account storage
• D. Manages the virtual warehouse cache to speed up queries

Answer: A

NEW QUESTION 3

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

• A. Use data encryption.
• B. Use dynamic data masking.
• C. Use secure materialized views.
• D. Revoke all roles for functional managers and end users.

Answer: B

NEW QUESTION 4

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

• A. Internal stages
• B. Incremental backups
• C. Time Travel
• D. Zero-copy clones
• E. Fail-safe

Answer: CE

Explanation:
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe. https://docs.snowflake.com/en/user-guide/data-availability.html

NEW QUESTION 5

What are the default Time Travel and Fail-safe retention periods for transient tables?

• A. Time Travel - 1 da
• B. Fail-safe - 1 day
• C. Time Travel - 0 day
• D. Fail-safe - 1 day
• E. Time Travel - 1 da
• F. Fail-safe - 0 days
• G. Transient tables are retained in neither Fail-safe nor Time Travel

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient

NEW QUESTION 6

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

• A. True
• B. False

Answer: A

NEW QUESTION 7

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

Answer: BC

Explanation:
https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING

NEW QUESTION 8

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

• A. The explain plan output is available graphically.
• B. An explain plan can be used to conduct performance analysis without executing a query.
• C. An explain plan will handle queries with temporary tables and the query profiler will not.
• D. An explain plan's output will display automatic data skew optimization information.

Answer: B

NEW QUESTION 9

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

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

NEW QUESTION 10

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

• A. True
• B. False

Answer: B

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

NEW QUESTION 11

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

• A. SnowSQL
• B. ODBC
• C. R
• D. HIVE

Answer: AB

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/connecting.html

NEW QUESTION 12

What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

• A. Installing and configuring hardware
• B. Patching software
• C. Physical security
• D. Maintaining metadata and statists

Answer: ABD

NEW QUESTION 13

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

• A. Their default role should be set to SYSTEMADMIN (the lower of the two)
• B. They should not set up multi_Factor Authentication (MFA)—as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
• C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
• D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
• E. They should use the SYSADMIN role to perform administrative work on database objects

Answer: ACE

NEW QUESTION 14

What are value types that a VARIANT column can store? (Select TWO)

• A. STRUCT
• B. OBJECT
• C. BINARY
• D. ARRAY
• E. CLOB

Answer: BD

Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics

NEW QUESTION 15

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

• A. Users
• B. Tables
• C. Databases
• D. Internal Stages

Answer: ABC

NEW QUESTION 16
......