[May 07, 2024] Fully Updated SnowPro Core (SnowPro-Core) Certification Sample Questions

Latest Snowflake SnowPro-Core Real Exam Dumps PDF

Snowflake SnowPro-Core Certification Exam is a popular certification program designed to recognize individuals who have the necessary knowledge and skills to work with Snowflake data warehousing solutions. SnowPro Core Certification Exam certification program is ideal for data professionals who want to enhance their knowledge and expertise in Snowflake data warehousing technologies. By passing the SnowPro-Core exam, individuals can demonstrate their proficiency in Snowflake's core concepts and become certified SnowPro-Core professionals.

The SnowPro Core Certification Exam certification exam focuses on core concepts and features of the Snowflake cloud data platform, including data modeling, data loading, security, performance optimization, and data sharing. To pass the SnowPro-Core examination, individuals must demonstrate their understanding of these core concepts and demonstrate their ability to apply them in a practical setting. SnowPro-Core exam is designed to test the proficiency of individuals in the use of Snowflake for data warehousing, data lakes, and data engineering.

 

NEW QUESTION # 121
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

• A. 48 hours
• B. 30 days
• C. 7 days
• D. 24 hours

Answer: D

NEW QUESTION # 122
Which formats are supported for unloading data from Snowflake?
Choose 2 answers

• A. Delimited (CSV, TSV, etc.)
• B. JSON
• C. ORC
• D. Avro

Answer: A,B

NEW QUESTION # 123
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

• A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
• B. Shares attached to listings in remote regions can be viewed from any account in an organization.
• C. The listing is replicated into all selected regions automatically, the data is not.
• D. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
• E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer: A,D

NEW QUESTION # 124
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

• A. A Warehouse can be configured to auto-resume when new queries are submitted
• B. A Warehouse can be resized while running
• C. Customers can change the size of the Warehouse after creation
• D. A Warehouse can be configured to suspend after a period of inactivity

Answer: B,D

NEW QUESTION # 125
When unloading data to an external stage, what is the MAXIMUM file size supported?

• A. 16 GB
• B. 1 GB
• C. 10 GB
• D. 5 GB

Answer: D

NEW QUESTION # 126
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

• A. One Login
• B. Authy
• C. Duo Security
• D. RSA SecurlD Access

Answer: C

NEW QUESTION # 127
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

• A. False
• B. True

Answer: A

NEW QUESTION # 128
Snowflake's hierarchical key mode includes which keys? (Select TWO).

• A. Secure view keys
• B. File keys
• C. Schema master keys
• D. Database master keys
• E. Account master keys

Answer: B,E

NEW QUESTION # 129
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

• A. False
• B. True

Answer: A

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

NEW QUESTION # 130
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.

• A. Database -> Schema -> Table -> Account
• B. Database -> Table -> Schema -> Account
• C. Account -> Database -> Schema -> Table
• D. Account -> Schema -> Database -> Table

Answer: C

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

NEW QUESTION # 131
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: C

NEW QUESTION # 132
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

• A. Secure User-Defined Functions (UDFs)
• B. Secure Views
• C. Stored Procedures
• D. Tables
• E. Schemas
• F. Roles

Answer: A,E,F

NEW QUESTION # 133
When can a Virtual Warehouse start running queries?

• A. When its provisioning is complete
• B. 12am-5am
• C. After replication
• D. Only during administrator defined time slots

Answer: D

NEW QUESTION # 134
In which use cases does Snowflake apply egress charges?

• A. Query result retrieval
• B. Database replication
• C. Data sharing within a specific region
• D. Loading data into Snowflake

Answer: C

Explanation:
Cloud providers apply data egress charges in either of the following use cases:
Data is transferred from one region to another within the same cloud platform.
Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the%20cloud%20platform.

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

• A. True
• B. False

Answer: A

Explanation:
You can experiment the same with snowflake UI.

NEW QUESTION # 136
......

Snowflake SnowPro-Core Dumps - Secret To Pass in First Attempt: https://www.testsimulate.com/SnowPro-Core-study-materials.html