Snowpro Core Certification Exam; Questions with Verified Solutions

Snowpro Core Certification Exam; Questions with
Verified Solutions
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 Correct Ans-d. 12




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; Correct Ans-[X] SELECT COUNT(*)

FROM EMPLOYEE;


[X] DESCRIBE TABLE EMPLOYEE;

, Snowpro Core Certification Exam; Questions with
Verified Solutions
Which semi-structured data formats do Snowflake natively store and query? Select all that

apply.


[] JSON


[] ORC


[] CSV


[] XML


[] RCFile


[] SequenceFile


[] PDF


[] AVRO


[] PARQUET Correct Ans-[X] JSON


[X] ORC


[X] XML


[X] AVRO


[X] PARQUET

, Snowpro Core Certification Exam; Questions with
Verified Solutions
How many accounts can a data consumer share a shared database with? Choose one correct

value.


a. 1


b. 5


c. 0


d. 10 Correct Ans-C. 0




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. Correct Ans-B. Information schema.




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


False


True Correct Ans-False

, Snowpro Core Certification Exam; Questions with
Verified Solutions

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 Correct Ans-A. 0.8




Cloning a table copies the underlying data effectively doubling storage costs. True or false?


False


True Correct Ans-False




When copying files from a table to an internal stage using the COPY INTO <location>

command, the results are split into multiple files. Which copy option would I use to ensure

only one file is produced? Choose one correct value.


a. OVERWRITE


b. SINGLE


c. MAX_FILE_SIZE