- All Exams Instant Download
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
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?
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''?
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.)
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.
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.
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?
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.)
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.
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?
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
