SnowPro Core V1

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more DatabasesB . A Database may contain one or more SchemasC . A Schema is a logical grouping of Database ObjectsD . Each Schema is contained within a WarehouseView AnswerAnswer:...

What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul)B . Through the DATA_SHARE=TRUE parameterC . Through SQL commandsD . Through the enable__share=true parameterE . Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: C,D

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clauseB . Incoming data can be joined with other tablesC . Columns can be reorderedD . Columns can be omittedE . Row level access...

What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Which of the following roles is recommended to be used to create and manage users and roles?A . SYSADMINB . SECURITYADMINC . PUBLICD . ACCOUNTADMINView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

Which statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitionsB . The database administrator must define the clustering methodology for each Snowflake table.C . The clustering key must be included on the COPV command when loading data into Snowflake.D ....

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of valuesB . Micro-partitions are immutable objects that support the use of Time Travel.C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehousesD . Rows are automatically stored...

True or False: Once created, a micro-partition will never be changed.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>)B . COPYC . SUM(<< column value >>)D . UPDATEView AnswerAnswer: B,C,D

True or False: You can query the files in an External Stage directly without having to load the data into a table.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used...