- All Exams Instant Download
Following objects can be cloned in snowflake
Following objects can be cloned in snowflake A. Permanent table B. Transient table C. Temporary table D. External tables E. Internal stagesView AnswerAnswer: A,B,E Explanation: In Snowflake, the ability to clone objects is an important feature for quickly duplicating the schema and data of various database objects. Here's the capability...
You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required. What type of table you will...
Below are the rest APIs provided by Snowpipe
Below are the rest APIs provided by Snowpipe A. insertFiles B. insertReport C. loadDataView AnswerAnswer: A Explanation: A. insertFiles: This is a REST API provided by Snowpipe in Snowflake. The insertFiles API endpoint is used to tell Snowpipe to load data from files that you stage in a cloud storage...
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements?
The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include: 1) Finance and Vendor Management team members who require reporting and visualization 2) Data Science team members who require...
The kafka connector creates one pipe for each partition in a Kafka topic.
The kafka connector creates one pipe for each partition in a Kafka topic.A . TRUEB . FALSEView AnswerAnswer: A Explanation: The connector creates one pipe for each partition in a Kafka topic. The format of the pipe name is: SNOWFLAKE_KAFKA_CONNECTOR_<connector_name>_<PIPE_table_name>_<partition_number> https://docs.snowflake.com/en/user-guide/kafka-connector-manage.html#dropping-pipes
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?...
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.A . TRUEB . FALSEView AnswerAnswer: A Explanation: Some of the internal optimizations for views require access to the underlying data in the base tables for the view....
According to Snowflake recommended best practice, how should these requirements be met?
A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors. The company’s Snowflake Architects need to design a solution that would allow the...
Which is that role?
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database. Which is that role?A . IMPORTED PRIVILEGESB . SHARED PRIVILEGESC . IMPORT SHAREView AnswerAnswer: A Explanation: IMPORTED PRIVILEGES Grants ability to enable roles other than the owning...
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...
