Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 45)

When should a multi-cluster warehouse be used in auto-scaling mode?

  1. When it is unknown how much compute power is needed
  2. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
  3. If the runtime of the executed query is very slow
  4. When a large number of concurrent queries are run on the same warehouse

Answer(s): D



What happens when a cloned table is replicated to a secondary database? (Choose two.)

  1. A read-only copy of the cloned tables is stored.
  2. The replication will not be successful.
  3. The physical data is replicated.
  4. Additional costs for storage are charged to a secondary account.
  5. Metadata pointers to cloned tables are replicated.

Answer(s): C,D



Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  1. Amazon Web Services
  2. Docker
  3. IBM Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Oracle Cloud

Answer(s): A,D,E



What is a limitation of a Materialized View?

  1. A Materialized View cannot support any aggregate functions
  2. A Materialized View can only reference up to two tables
  3. A Materialized View cannot be joined with other tables
  4. A Materialized View cannot be defined with a JOIN

Answer(s): D



In the Snowflake access control model, which entity owns an object by default?

  1. The user who created the object
  2. The SYSADMIN role
  3. Ownership depends on the type of object
  4. The role used to create the object

Answer(s): D



What is the minimum Snowflake edition required to use Dynamic Data Masking?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake (VPC)

Answer(s): B



Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  1. Compute resources
  2. Query execution
  3. Authentication
  4. Data storage
  5. Metadata

Answer(s): C,E



A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

  1. Row access policies
  2. Data masking policies
  3. Data encryption
  4. Role based access control

Answer(s): B



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

S
sushant
6/28/2023 4:52:00 AM

good questions

A
A\MAM
6/27/2023 5:17:00 PM

q-6 ans-b correct. https://docs.paloaltonetworks.com/pan-os/9-1/pan-os-cli-quick-start/use-the-cli/commit-configuration-changes

U
unanimous
12/15/2023 6:38:00 AM

very nice very nice

A
akminocha
9/28/2023 10:36:00 AM

please help us with 1z0-1107-2 dumps

J
Jefi
9/4/2023 8:15:00 AM

please upload the practice questions

T
Thembelani
5/30/2023 2:45:00 AM

need this dumps

A
Abduraimov
4/19/2023 12:43:00 AM

preparing for this exam is overwhelming. you cannot pass without the help of these exam dumps.

P
Puneeth
10/5/2023 2:06:00 AM

new to this site but i feel it is good

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.

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

good questions

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

Delayed the exam until December 29th.

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

A and D are True

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

good one with explanation

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

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

AI Tutor 👋 I’m here to help!