How do you refresh a materialized view?
How do you refresh a materialized view?A . ALTER VIEW <MV_NAME> REFRESH B. REFRESH MATERIALIZED VIEW <MV_NAME> C. Materialized views are automatically refreshed by snowflake and does not require manual interventionView AnswerAnswer: C Explanation: Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view...
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...
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 PRIVILEGES B. SHARED PRIVILEGES C. IMPORT SHAREView AnswerAnswer: A Explanation: IMPORTED PRIVILEGES Grants ability to enable roles other than the owning...
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 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...
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)A . A task scheduled in a UTC-based schedule will have no issues with the time changes. B. Task schedules can be designed to follow specified or local time zones to accommodate the...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
Which of the below operations are allowed on an inbound share data?
Which of the below operations are allowed on an inbound share data?A . MERGE B. CREATE/DROP/ALTER TABLE C. ALTER SCHEMA D. SELECT WITH JOIN E. SELECT WITH GROUP BY F. INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...
What should the Architect do to enable the Snowflake search optimization service on this table?
An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics. What should the Architect do to enable the Snowflake search optimization service on this table?A . Assume role with OWNERSHIP on future tables and ADD SEARCH...
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...