- All Exams Instant Download
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
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)
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.)
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?
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?
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''?
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)
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.
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 answers
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.
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...
