Snowpro Core Certification; Questions and Answers Rated A+

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