Snowpro Core Certification; Questions and Answers
Rated A+
d. 12 Correct Ans-The account usage share contains a database called SNOWFLAKE. The
views in this database are used to provide fine-grained metrics at the account and object
level. What is the maximum number of months data in these views available for? Choose one
correct value.
a. 6
b. 3
c. 9
d. 12
[X] SELECT COUNT(*) FROM EMPLOYEE;
[X] DESCRIBE TABLE EMPLOYEE; Correct Ans-Which queries would not require the use of a
Virtual Warehouse and instead would make use of the metadata cache? Select all that apply.
[] SELECT COUNT(*) FROM EMPLOYEE;
[] SELECT * FROM TABLE(FLATTEN(INPUT => PARSE_JSON('[1, ,77]'))) F;
[] DESCRIBE TABLE EMPLOYEE;
[] SELECT EMP_ID, NAME, ADDRESS FROM EMPLOYEE;
, Snowpro Core Certification; Questions and Answers
Rated A+
[X] JSON
[X] ORC
[X] XML
[X] AVRO
[X] PARQUET Correct Ans-Which semi-structured data formats do Snowflake natively store
and query? Select all that apply.
[] JSON
[] ORC
[] CSV
[] XML
[] RCFile
[] SequenceFile
[] PDF
[] AVRO
[] PARQUET
, Snowpro Core Certification; Questions and Answers
Rated A+
C. 0 Correct Ans-How many accounts can a data consumer share a shared database with?
Choose one correct value.
a. 1
b. 5
c. 0
d. 10
B. Information schema. Correct Ans-What does each database created in an account
automatically include? Choose one correct value.
a. Directory table.
b. Information schema.
c. Information table.
d. Auditing table.
, Snowpro Core Certification; Questions and Answers
Rated A+
False Correct Ans-The COPY INTO <table> statement does NOT require a virtual warehouse
to run. True or false?
False
True
A. 0.8 Correct Ans-Which result from the APPROXIMATE_SIMILARITY estimation function
would indicate two sets of rows overlap significantly but are not identical? Choose one
correct value.
a. 0.8
b. 0.0
c. 1
d. 0.1
False Correct Ans-Cloning a table copies the underlying data effectively doubling storage
costs. True or false?
False
Rated A+
d. 12 Correct Ans-The account usage share contains a database called SNOWFLAKE. The
views in this database are used to provide fine-grained metrics at the account and object
level. What is the maximum number of months data in these views available for? Choose one
correct value.
a. 6
b. 3
c. 9
d. 12
[X] SELECT COUNT(*) FROM EMPLOYEE;
[X] DESCRIBE TABLE EMPLOYEE; Correct Ans-Which queries would not require the use of a
Virtual Warehouse and instead would make use of the metadata cache? Select all that apply.
[] SELECT COUNT(*) FROM EMPLOYEE;
[] SELECT * FROM TABLE(FLATTEN(INPUT => PARSE_JSON('[1, ,77]'))) F;
[] DESCRIBE TABLE EMPLOYEE;
[] SELECT EMP_ID, NAME, ADDRESS FROM EMPLOYEE;
, Snowpro Core Certification; Questions and Answers
Rated A+
[X] JSON
[X] ORC
[X] XML
[X] AVRO
[X] PARQUET Correct Ans-Which semi-structured data formats do Snowflake natively store
and query? Select all that apply.
[] JSON
[] ORC
[] CSV
[] XML
[] RCFile
[] SequenceFile
[] AVRO
[] PARQUET
, Snowpro Core Certification; Questions and Answers
Rated A+
C. 0 Correct Ans-How many accounts can a data consumer share a shared database with?
Choose one correct value.
a. 1
b. 5
c. 0
d. 10
B. Information schema. Correct Ans-What does each database created in an account
automatically include? Choose one correct value.
a. Directory table.
b. Information schema.
c. Information table.
d. Auditing table.
, Snowpro Core Certification; Questions and Answers
Rated A+
False Correct Ans-The COPY INTO <table> statement does NOT require a virtual warehouse
to run. True or false?
False
True
A. 0.8 Correct Ans-Which result from the APPROXIMATE_SIMILARITY estimation function
would indicate two sets of rows overlap significantly but are not identical? Choose one
correct value.
a. 0.8
b. 0.0
c. 1
d. 0.1
False Correct Ans-Cloning a table copies the underlying data effectively doubling storage
costs. True or false?
False
