- All Exams Instant Download
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)A . They can include ORDER BY clauses.B . They cannot include nested subqueries.C . They can include context functions, such as CURRENT_TIME().D . They can support MIN and MAX aggregates.E . They can support inner joins,...
How can cloning the STAGING schema be achieved?
An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The...
Which Snowflake feature can the Architect use to accomplish this?
An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?A . Search optimization serviceB . Materialized viewC . Time TravelD . Zero-copy cloningE . Secure viewsView AnswerAnswer: D Explanation: Zero-copy cloning is a Snowflake feature that...
To meet these requirements, which design elements must be implemented?
An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows: 1) Use Tri-Secret Secure in Snowflake 2) Share some information stored in a view with another Snowflake customer 3) Hide portions of sensitive information from some columns...
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)A . Choose columns that are frequently used in join predicates.B . Choose lower cardinality columns to support clustering keys and cost effectiveness.C . Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.D ....
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?A . The Connector only works in Snowflake regions that use AWS infrastructure.B . The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.C . The Connector creates and manages its...
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?
A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?A . 1) OAuth (either Snowflake OAuth or External OAuth) 2) External browser 3) Okta native authentication 4) Key Pair Authentication, mostly used...
What would cause this to occur?
A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis. After setting up the...
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)A . Shared databases are read-only.B . Shared databases must be refreshed in order for new data to be visible.C . Shared databases cannot be cloned.D . Shared databases are...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
