- All Exams Instant Download
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...
Which of the following are characteristics of Snowflake’s parameter hierarchy?
Which of the following are characteristics of Snowflake’s parameter hierarchy?A . Session parameters override virtual warehouse parameters.B . Virtual warehouse parameters override user parameters.C . Table parameters override virtual warehouse parameters.D . Schema parameters override account parameters.View AnswerAnswer: A
You need to choose a high cardinality column for the clustering key
You need to choose a high cardinality column for the clustering keyA . TRUEB . FALSEView AnswerAnswer: A Explanation: Choosing a high cardinality column for the clustering key can be beneficial, especially if the column is frequently used in filters, join conditions, or range queries. High cardinality means that the...
