- All Exams Instant Download
What are purposes for creating a storage integration? (Choose three.)
What are purposes for creating a storage integration? (Choose three.)A . Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.B . Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud...
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?
A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM...
Which of the following will enable this type of data ingestion?
A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?A . The company must have a Snowflake account in each cloud region to be able to ingest data to that account.B . The...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache.B . Snowflake persists the data results for 24 hours.C . Each time persisted results for a query are used, a 24-hour retention period is reset.D ....
What Snowflake features should be leveraged when modeling using Data Vault?
What Snowflake features should be leveraged when modeling using Data Vault?A . Snowflake’s support of multi-table inserts into the data model’s Data Vault tablesB . Data needs to be pre-partitioned to obtain a superior data access performanceC . Scaling up the virtual warehouses will support parallel processing of new source...
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
