Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

Snowflake SnowPro Core Exam Actual Questions

The questions for SnowPro Core were last updated on Oct. 18, 2024.
  • Viewing page 1 out of 117 pages.
  • Viewing questions 1-10 out of 1167 questions
 

Topic 1 - Single Topic

Question #1 Topic 1

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

  • A. Micro-partitions
  • B. Clustering keys
  • C. Key partitions
  • D. Clustered partitions
Reveal Solution Hide Solution   Discussion   30

Correct Answer: B 🗳️

Question #2 Topic 1

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  • A. Custom
  • B. Economy
  • C. Optimized
  • D. Standard
Reveal Solution Hide Solution   Discussion   24

Correct Answer: BD 🗳️

Question #3 Topic 1

True or False: A single database can exist in more than one Snowflake account.

  • A. True
  • B. False
Reveal Solution Hide Solution   Discussion   19

Correct Answer: B 🗳️

Question #4 Topic 1

Which of the following roles is recommended to be used to create and manage users and roles?

  • A. SYSADMIN
  • B. SECURITYADMIN
  • C. PUBLIC
  • D. ACCOUNTADMIN
Reveal Solution Hide Solution   Discussion   43

Correct Answer: B 🗳️

Question #5 Topic 1

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  • A. True
  • B. False
Reveal Solution Hide Solution   Discussion   24

Correct Answer: A 🗳️

Question #6 Topic 1

Select the different types of Internal Stages: (Choose three.)

  • A. Named Stage
  • B. User Stage
  • C. Table Stage
  • D. Schema Stage
Reveal Solution Hide Solution   Discussion   14

Correct Answer: ABC 🗳️

Question #7 Topic 1

True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.

  • A. True
  • B. False
Reveal Solution Hide Solution   Discussion   11

Correct Answer: B 🗳️

Question #8 Topic 1

Account-level storage usage can be monitored via:

  • A. The Snowflake Web Interface (UI) in the Databases section
  • B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
  • C. The Information Schema -> ACCOUNT_USAGE_HISTORY View
  • D. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View
Reveal Solution Hide Solution   Discussion   16

Correct Answer: B 🗳️

Question #9 Topic 1

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  • A. Number of users
  • B. Warehouse size
  • C. Amount of data processed
  • D. # of clusters for the Warehouse
Reveal Solution Hide Solution   Discussion   43

Correct Answer: BD 🗳️

Question #10 Topic 1

Which statement best describes `clustering`?

  • A. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
  • B. The database administrator must define the clustering methodology for each Snowflake table
  • C. The clustering key must be included on the COPY command when loading data into Snowflake
  • D. Clustering can be disabled within a Snowflake account
Reveal Solution Hide Solution   Discussion   12

Correct Answer: A 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel