- All Exams Instant Download
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...
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO) A. VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A, B Explanation: Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types...
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the queryB . Micro-partitions have been reclustered since the query was last runC . The new query is run...
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 is the minimum Snowflake edition required to create a materialized view?
What is the minimum Snowflake edition required to create a materialized view?A . Standard EditionB . Enterprise EditionC . Business Critical EditionD . Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query...
Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?A . LOADB . copyC . GETD . PUTView AnswerAnswer: D Explanation: The PUT command is used to load data into an internal stage in Snowflake. This command uploads data files from a local file system to a named...
What is a best practice after creating a custom role?
What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role.B . Assign the custom role to the SYSADMIN roleC . Assign the custom role to the PUBLIC roleD . Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: Assigning the custom...
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLESB . POLICY_REFERENCESC . QUERY_HISTORYD . RESOURCE_MONIT ORSE . ACCESS_HISTORYView AnswerAnswer: B, E Explanation: To evaluate the details of dynamic data masking, the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used. The...
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.A . TrueB . FalseView AnswerAnswer: B Explanation: Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake recommends that for optimal load performance, data files should be...
Which feature is only available in the Enterprise or higher editions of Snowflake?
Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level securityB . SOC 2 type II certificationC . Multi-factor Authentication (MFA)D . Object-level access controlView AnswerAnswer: A Explanation: Column-level security is a feature that allows fine-grained control over access to specific columns within a table....
