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

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Snowflake SnowPro Core Exam Actual Questions

The questions for SnowPro Core were last updated on June 25, 2024.
  • Viewing page 1 out of 111 pages.
  • Viewing questions 1-10 out of 1110 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   29

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   23

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   18

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   44

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   23

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   13

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   10

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   15

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   39

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   12

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 ...