~/snowflake-cof-c03 · study ▊

practice sheet · all objectives switch to smart practice →

SnowPro® Core Certification

0/148 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

Q_22 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_23 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_24 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_25 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_26 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_27 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_28 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_29 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_30 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_31 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_32 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_33 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_34 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_35 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_36 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_37 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_38 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_39 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_40 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_41 domain/d2 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_42 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_43 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_44 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_45 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_46 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_47 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_48 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_49 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_50 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_51 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_52 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_53 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_54 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_55 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_56 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_57 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_58 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_59 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_60 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_61 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_62 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_63 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_64 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_65 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_66 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_67 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_68 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_69 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_70 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_71 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_72 domain/d4 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_73 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_74 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_75 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_76 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_77 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_78 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_79 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_80 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_81 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_82 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_83 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_84 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_85 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_86 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_87 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_88 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_89 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_90 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_91 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_92 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_93 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_94 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_95 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_96 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_97 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_98 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_99 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_100 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_101 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_102 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_103 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_104 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_105 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_106 domain/d5 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_107 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_108 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_109 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_110 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_111 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_112 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_113 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_114 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_115 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_116 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_117 domain/d6 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_118 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_119 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_120 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_121 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_122 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_123 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_124 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_125 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_126 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_127 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_128 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_129 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_130 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_131 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_132 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_133 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_134 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_135 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_136 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_137 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_138 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_139 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_140 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_141 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_142 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_143 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_144 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_145 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_146 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_147 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_148 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

146 questions locked

unlock all 146 questions