~/snowflake-cof-c03 · study ▊

practice sheet · all objectives switch to smart practice →

SnowPro® Core Certification

0/21 checked

Q_01 domain/d1 · medium single discuss →

A data architect explains that Snowflake's architecture provides the simplicity of centralized data management while still delivering strong query performance and scale-out capability. Which statement accurately describes how Snowflake's architecture achieves this?

A It uses a pure shared-disk architecture where all nodes read from one central repository with no local storage.
B It is a hybrid of shared-disk and shared-nothing architectures, using a central data repository accessible to all compute nodes while processing queries with MPP clusters where each node stores a portion of the data locally.
C It is a pure shared-nothing architecture where each node owns a permanent, non-shared partition of the data set.
D It requires customers to install and manage MPP clusters on private cloud infrastructure to gain scale-out benefits.

Q_02 domain/d1 · medium single discuss →

An engineering team needs to run a transactional workload that requires low-latency random reads and writes, row locking, and enforcement of unique and referential integrity constraints, alongside their analytical data. Which Snowflake table type should they choose?

A Apache Iceberg tables
B Standard Snowflake tables
C Hybrid tables
D External tables stored in cloud storage

Q_03 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_04 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_05 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_06 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_07 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_08 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_09 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_10 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_11 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_12 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_13 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_14 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_15 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_16 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_17 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_18 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_19 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_20 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_21 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

19 questions locked

unlock all 19 questions