Snowflakes Preparation Exam || All Answered Correctly

Multi-cluster shared data correct answers Which of the following terms best describes Snowflake's database architecture? Pruning correct answers What technique does Snowflake use to limit the number of micro-partitions scanned by each query? All data in Snowflake is encrypted correct answers Which of the following statements apply to Snowflake in terms of security? Select all that apply. Snowflake leverages a role-based access control model correct answers Which of the following statements apply to Snowflake in terms of security? Select all that apply. Result caching , Metadata caching , warehouse caching correct answers Which of the following are types of caching use by Snowflake? view correct answers What is the recommended approached for making a variant column accessible in a BI tool? Native SQL correct answers Which of the following best describes Snowflake's processing engine? Optimized storage based on repeated elements correct answers Which of the following are true about the variant data type in Snowflake? Can be queried using JSON path notation correct answers Which of the following are true about the variant data type in Snowflake? * Are the physical data files that comprise Snowflake's logical tables * Enable horizontal and vertical query pruning correct answers Snowflake micro-partitions. Micro-partitions: ELT correct answers Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? auto-suspend and auto-resume correct answers Which of the following are options when creating a Virtual Warehouse? * Adds clusters automatically based on query activity *Scales down when query activity slows correct answers Which of the following are true of Multi-Cluster warehouses? * Physical location of the Stage * Gzip compression efficiency correct answers The following factors affect data load rates: