Snowflake SnowPro Certification Study Guide


0123456780123 2 8 462108







!

!"#$%&'(%)*'!+
)
*$
,$!-%./%0-$
1!23456789:;<=>?@;A>BC@>BC@:D><B
EF5GH;@IJ<H?KJ9DL<;MA8N@B@;9JJO9=9>J9PJ@9A<L7@:DQRS3T
UFV<<NJ@IJ<H?KJ9DL<;M8D;>9J@?J9D@RS3W
E./%0-$
1!*+X& !/
$Y

!%/$YZ,&*$
-%

!X$%&'[\]^_2`;H@
Ua%0'%!+./%0-$
1!'!+X*,!

!*
X
*
!X
&!b
cdef&$
*g#$&+
!h.

!'Z



ide.*/j$!g#$&+
!h.

!'Z


254kHJD>8IJHAD@;l7m9;@?n9D9
o



!

!"X%pq%/!/
+%-./%0-$
1!r+
X
*
!X
&![,%



!/
p!
/''!+X*q
%_2347D<;9N@8n9D9P9A@A
EFI<M:HD@8s>;DH9J69;@m<HA@A
UFIJ<H?7@;=>C@A8t;<BDuB?
v



!

!#$%&'w,x!X
.
%
j!%q
*%/+b2345677y
EF5GH;@zJ<PA
UFVIK
{D<`a% 0
!+
%
j!X%+
+X
$X&$

!'b25?9>JO9=@;9N@<L9JJC<M:;@AA@??9D9AD<;9N@l>BCJH?>BN?9D9AD<;@?9CC<;?>BN
>M@`;9=@J;@D@BD><B:<J>CO9B?L9>JA9L@:;<C@?H;@A
|R45G
H;*@X
I<f* X%+%-

/'}p
~%/+Y+
!p+'%!+#%pq&
!$!)!
j!b234567uIR
M:HD@
#%pq&
!X
/r
+X
$!%&

+€&!*!+
!&//*/j[\]^_2t9JA@

*X
+!)*X!+'%!+#$%&'.!)*X!+q%)*'!b2347@CH;>DOk9B9N@M@BD
EF‚BL;9AD;HCDH;@k9B9N@M@BD
UFk@D9?9D9k9B9N@M@BD
oFƒH@;O„:D>M>G9D><B
 } !./%0-$
1!r+.
%
j![Z†_
/'#%pq&
![a_$
Y!+
cde.!q


!
/'‡/'!q!/'!/

ide\%j!

!
/'Z!q!/'!/
2547@:9;9D@9B?‚B?@:@B?@BD
H:<;‡?/<
ŠB''9*
H*D%</M9

%p&$
*q$!ˆ*
&
$
!
%&+!+hf&$
*g#$&+
!p!
/+*/'*)*'&
$ˆ*
&
$
!
%&+!+X
/‰‰‰27C9J@
D>C9JJO
Ef&$
*g#$&+
!
&/%--X$&+
!+0
!/
X
*)*
Y+$%0+'%0/[\]^_2`;H@
U./%0-$
1!&+!+}‹.‡g.Œ[\]^_2`;H@
o


*+./%0-$
1!r++!p*g+
&X
&!''



Yq!X
$$!'b2s5Ž‚5`
v



!

!

!!
Yq!+%-X
X
*/j*/./%0-$
1!b23469;@m<HA@
EFk@D9?9D9
UFŽ@AHJDA
{}$$X
X
!'



!X$!
!'*-

!&/'!$Y*/j'


X

/j!+[\]^_2`;H@
 

,
0123456780123 2 8 462108



=387
5

!"#$%!
&$
#'%$!()
*+,!"#-!

$+!*%!
$!"!*+./*"$"-!

$&$!"#$%!*!/*.$-0!12345678282982:6;55<
7><23?>42@8=A84593@6567@4><BC@54DE><BFG957828>6><H8=>78257>I>2:66@6J5<757FK>H56><L3MJ@25F
15N4H
>Q

!"#$%!O$"!()
*+,!"#-!

$&$!"#$%!*!/*.$-0!P2623456H84>3@6><I38;3@228;=56FP2=>H56><295L=3@7
56=8D54F
 R


!"#$%!S$%'/%!()
*+,!"#-!

$&$!"#$%!*!/*.$-0!P2623456456@=263IC@54>56298298H5;55<5T5Q@257U>29><295
J862VW93@46X866@M><B@<754=D><B7828986<:2Q98<B57YFP2=>H56><295L=3@7154H>Q56K8D54F
Z)[)#
'\! )'%#]$&!+$$"%!#!
.$!!^&$$_*%*+,!))#'+!`*
!\
a!#&!\b'&$!*+!#&"$&!#!
.$!!a+#`c/d$!
+!efghi0!j8=65
Z


!&$!\.*/k*/*l!m#+$%-0!n828Q5<2546><Q5428><45B>3<6
ZZ
o#`!]+l!.*/k*/*l!b#+$%!*%!l#'&!"!&$^/*)$"!*+-0!p7828q3<56><845B>3<
ZI43r<
2F

!"#$%!*!]$+!kl!s'#]*)s!]*)&#t^&**#+%0!uJ842>2>3<6Q95M57356<:2<55723;575I><57@J
1<3UI=8v575254M><568<7Q458256>2F
Zw
x!^&**#+*+,!*%!'#]*)//l!)#]^/$$"!*+!
$!+'&/!*+,$%*#+!#&"$&!efghi0!G4@5
Zy
z$`!{&**#+%!&$!k%$"!#+!^
l%*)/!^&#^$&*$%!efghi0!G4@5
Z|
o#`!"#$%!a+#`c/d$!#^*]*b$!%#&,$!#c!%$]*t%&')'&$"!"-0!}5J582575=5M5<26U>29><295624><B6
Z
o#`!c&!k)d!"#$%!
$!f*]$!f&.$/!^&#$)*#+!,#-0!~78D6
ZN
m$&#t(#^l!(/#+*+,!#^$&$%!#+!]#&$!
+!€'%!
$!]$"!efghi0!j8=65EP2:68M5287828E3<=D3J5482>3<
ZG9R5
45f
$&$%!!"*cc$&$+)$!*+!%#&,$!)#%!//#)*#+!k$`$$+!%&')'&$"!+"!%$]*t%&')'&$"!"!efghi0!j8=65E
:6<37>II545<Q5
r[
\!'%$&!)+!k$!%%*,+$"!]'/*^/$!&#/$%!efghi0!j8=65Eu@654Q8<;5866>B<57M@=2>J=543=56
r98H5
8‚cQ!Q5!6'6%$23&!>)2&$86U5
$%!+!#k€$)ƒ!`
!^$&]*%%*#+%!"#!#
$&%!
.$-0!u==@6546U>2929543=52982Q4582572953;„5Q2U>==
==86295@65468<743=56298229543=52982Q4582572953;„5Q243=5@J23F
rZ


*)
!$+)&l^*#+!]$
#"!*%!'%$"-0!u†1V‡ˆ1243<B†<Q4DJ2>3<
rr


!&$!
$!
&$$!s
*,
$&!$"**#+%s!e%&#+,$&!%$)'&*li!#c!a+#`c/d$-0!‰Y†<254J4>65
ZŠ†<254J4>65I3415<6>2>H5n828
rŠ?>42@8=‹4>H8251<3UI=8v5
rw


!%$)'&*l!^&#$)*#+%!"#$%!a+#`c/d$!^&#.*"$0!E1><B=51>B<Œ<2943@B9I575482578@295<2>Q82>3<
‹54>37>Q}5v5D><B3I5<Q4DJ2577828