Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors

Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 11)

SnowPro Core PDF — 1300 Questions

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  1. The VALIDATION_MODE option is used when creating an Internal Stage
  2. VALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command
  3. The VALIDATION_MODE option will validate data to be loaded by the COPY statement while completing the load and will return the rows that could not be loaded without error
  4. The VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors

Answer(s): B,D



What privileges are required to create a task?

  1. The GLOBAL privilege CREATE TASK is required to create a new task.
  2. Tasks are created at the Application level and can only be created by the Account Admin role.
  3. Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants.
  4. The role must have access to the target schema and the CREATE TASK privilege on the schema itself.

Answer(s): D



What are the three things customer want most from their enterprise data warehouse solution? (Choose three.)

  1. On-premise availability
  2. Simplicity
  3. Open source based
  4. Concurrency
  5. Performance

Answer(s): B,D,E



True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

  1. True
  2. False

Answer(s): A



When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

  1. Concurrency
  2. Performance

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html



What is the minimum Snowflake edition that provides data sharing?

  1. Standard
  2. Premier
  3. Enterprise
  4. Business Critical Edition

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing



True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

  1. True
  2. False

Answer(s): A



True or False: You can query the files in an External Stage directly without having to load the data into a table.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-external-intro.html



PDF
Viewing page 11 of 139

Share your comments for Snowflake SnowPro Core exam with other users:

A
Ashok Kumar
1/2/2024 6:53:00 AM

the correct answer to q8 is b. explanation since the mule app has a dependency, it is necessary to include project modules and dependencies to make sure the app will run successfully on the runtime on any other machine. source code of the component that the mule app is dependent of does not need to be included in the exported jar file, because the source code is not being used while executing an app. compiled code is being used instead.

Anonymous
M
Merry
7/30/2023 6:57:00 AM

good questions

Anonymous
V
VoiceofMidnight
12/17/2023 4:07:00 PM

Delayed the exam until December 29th.

UNITED STATES
U
Umar Ali
8/29/2023 2:59:00 PM

A and D are True

Anonymous
V
vel
8/28/2023 9:17:09 AM

good one with explanation

Anonymous
G
Gurdeep
1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.

CANADA
AI Tutor 👋 I’m here to help!