Computer Architecture > EXAM > SnowPro Advanced ALL ANSWERS 100% CORRECT SPRING FALL-2023/24 LATEST EDITION GUARANTEED GRADE A+ (All)

SnowPro Advanced ALL ANSWERS 100% CORRECT SPRING FALL-2023/24 LATEST EDITION GUARANTEED GRADE A+

Document Content and Description Below

True or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). True True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for MFA and SSO). False How does Snowflake encrypt data? Automatic 256-bit AES encryption of data (at rest and in transit); 128-bit or 256-bit AES encryption of all files staged for loading/unloading data. True or False: If the table's micro-partitions have changed(Re clustered or consolidated) due to changes to other data in table it will invalidate the persisted Query Results True True or False: Each time a query result is used the 24hr retention period is reset? True. But it is only retained a maximum of 31 days Micro-partitions store? - The range of values for each of the columns in the micro-partition. - The number of distinct values. - Additional properties used for both optimization and efficient query processing. True or False: Snowflake uses columnar scanning of partitions so that an entire partition is not scanned if a query only filters by one column. True True or False: Snowflake does not prune micro-partitions based on a predicate with a subquery, even if the subquery results in a constant. True Clustering Information Maintained for Micro-partitions - The total number of micro-partitions that comprise the table. - The number of micro-partitions containing values that overlap with each other (in a specified subset of table columns). - The depth of the overlapping micro-partitions. What does clustering depth store information about? The clustering depth for a populated table measures the average depth (1 or greater) of the overlapping micro-partitions for specified columns in a table. NOTE: The smaller the depth the better clustered a table is. A table with no micro-partitions (i.e. an unpopulated/empty table) has a clustering depth of? 0 True or False: You can cluster materialized views just like tables? True To experience any benefits from clustering, table data must be in what range of data size(KB/MB/GB/TB)? TB True or False: After a key has been defined on a table, no additional administration is required? True What tables are clustering useful for? Tables that are queried frequently and NOT changed frequently True or False: A single clustering key can contain one or more columns or expressions True Recommended amount of columns OR expressions per key 3 or 4 columns/expressions

[Show More]

Last updated: 3 years ago

Preview 1 out of 4 pages

Buy Now

Instant download