- All Exams Instant Download
What integration object should be used to place restrictions on where data may be exported?
What integration object should be used to place restrictions on where data may be exported?A . Stage integrationB . Security integrationC . Storage integrationD . API integrationView AnswerAnswer: C Explanation: In Snowflake, a storage integration is used to define and configure external cloud storage that Snowflake will interact with. This...
Which requirements will be addressed with this approach?
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)A . There needs to be fewer objects per tenant.B . Security and Role-Based Access...
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...
How can a Snowflake Architect meet this requirement with the LEAST amount of coding?
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding?...
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...
