SnowPro Core

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Which of the following statements is true of Snowflake micro-partitioning?A . Micro-partitioning has been known to introduce data skewB . Micro-partitioning: requires a partitioning schema to be defined up frontC . Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loadedD . Micro-partitioning can be disabled...

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 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:...

When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.A . The Pipe load history is reset to emptyB . The REFRESH parameter is set to TRUEC . Previously loaded files will be ignoredD . All of the aboveView AnswerAnswer: A

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

How many shares can be consumed by single Data Consumer?A . 1B . 10C . 100, but can be increased by contacting supportD . UnlimitedView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)A . Customers can change the size of the Warehouse after creationB . A Warehouse can be resized while runningC . A Warehouse can be configured to suspend after a period of inactivityD . A Warehouse can...

True or False: Users are able to see the result sets of queries executed by other users that share their same role.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 HourB . 3 HoursC . 12 hoursD . 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse