Snowpro Core Certification Exam Questions and Answers (Graded A)

Snowpro Core Certification Exam
Questions and Answers (Graded A)
d. 12 - ANSWER - 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; - ANSWER - 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;


[X] JSON
[X] ORC
[X] XML
[X] AVRO
[X] PARQUET - ANSWER - Which semi-structured data formats do Snowflake natively store and
query? Select all that apply.
[] JSON
[] ORC
[] CSV
[] XML

,[] RCFile
[] SequenceFile
[] PDF
[] AVRO
[] PARQUET


C. 0 - ANSWER - 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. - ANSWER - 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.


False - ANSWER - The COPY INTO <table> statement does NOT require a virtual warehouse
to run. True or false?
False
True


A. 0.8 - ANSWER - 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 - ANSWER - Cloning a table copies the underlying data effectively doubling storage costs.
True or false?
False
True


False - ANSWER - Micro-partitions can be modified once they have been created. True or
false?
True
False


a. DROP WAREHOUSE MY_WAREHOUSE; - ANSWER - What is the query to remove a virtual
warehouse? Choose one correct value.
a. DROP WAREHOUSE MY_WAREHOUSE;
b. CLEAR WAREHOUSE MY_WAREHOUSE;
c. DELETE WAREHOUSE MY_WAREHOUSE;
d. REMOVE WAREHOUSE MY_WAREHOUSE;


b. 60 - ANSWER - Virtual warehouses are billed on a per second basis. What is the minimum
number of seconds a virtual warehouse is billed for? Choose one correct value.
a. 120
b. 60
c. 10
d. 30


False - ANSWER - Data loading typically requires the use of a XXL Virtual Warehouse. True or
false?
True
False


14 - ANSWER - How many days is the query history maintained in the history tab of the classic
UI? Choose one correct value.