Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
 

Snowflake SnowPro Core Exam Actual Questions

The questions for SnowPro Core were last updated on July 24, 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 🗳️
Reference:
https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

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 🗳️
Reference:
https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

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 🗳️
Reference:
https://docs.snowflake.com/en/sql-reference/ddl-database.html

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   45

Correct Answer: D 🗳️
Reference:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

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 🗳️
Reference:
https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

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 🗳️
Reference:
https://docs.snowflake.com/en/user-guide/connecting.html

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 🗳️
Reference:
https://docs.snowflake.com/en/user-guide/admin-usage-billing.html

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   42

Correct Answer: BC 🗳️

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   13

Correct Answer: A 🗳️
Reference:
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

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
Loading ...
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in