Snowflake Test
What are the benefits of using materialized views versus standard views? (Choose 2)
A materialized view maintains the view by applying data changes from the base table, A materialized view optimizes query performance
What does the term "data clean room" refer to?
A. A mechanism for sharing and analyzing data in a privacy-preserving way
What internal Snowflake tool helps you track credit consumption using stable edges?
Account 360
Which open table format has Snowflake invested in supporting?
Apache Iceberg
Snowpipe provides ______________.
Automatic Data Ingest
What is a typical use case for a Dynamic Table?
Automating data transformations
What is one main advantage of using Dynamic Tables?
Base table changes are immediately reflected in the Dynamic Table
Which Snowflake edition includes capabilities like pipe replication and failover/failback?
Business Critical
Which of the following editions of Snowflake include compliance for HIPAA and PCI data?
Business Critical
How do users tell Snowflake how often to refresh a Dynamic Table?
By defining a time period known as "lag"
Snowflake's compute is more efficient for end users because it provides
Compute resources that scale to match demand
Snowflake ___________ are software components that enable seamless integration between Snowflake and other data systems/applications.
Connectors
What is a feature that can be activated on a Snowflake Marketplace listing to automatically keep the content up-to-date in whatever region or cloud the consuming party is in?
Cross-Cloud Auto-Fulfillment
What is one key feature that differentiates our Snowflake Marketplace from Databricks?
Cross-Cloud Auto-Fulfillment
Snowgrid is our mechanism for connecting Snowflake environments globally and across clouds. What are two advantages of Snowgrid? (Choose 2)
Cross-region and cross-cloud failover, Data sharing and replication
How often does account replication sync a master account with secondary accounts?
Customers control the frequency
Snowflake _____________ provides a secure environment where multiple parties can collaborate on sensitive or regulated data without exposing or moving the underlying data.
Data Clean Rooms
FactSet, Equifax, and Amplitude are examples of organizations sharing their ____________ on Snowflake's Marketplace.
Data Products
The Snowflake Marketplace is where customers go to discover, evaluate, and purchase _________ from some of the world's leading data and solution providers.
Data Products
What's one main security benefit of using Snowflake's built-in large language model (LLM) and machine learning (ML) functionality?
Data doesn't leave the secure Snowflake environment
Which of the following is an example of curated content, such as data or a Snowflake Native App, that's attached to a listing for the intent of sharing with others?
Data products
What are two advantages of using Snowpark? (Choose 2)
Data stays in Snowflake vs moving to another system, Developers use the tools and languages they prefer
The simplest form of Snowflake collaboration is making some data in a Snowflake account visible to another individual Snowflake account in the same cloud provider region. What is the term for this simple type of collaboration?
Direct Share
Why is it important for Snowflake to create stable edges? (Choose 3)
Displace the competition, Increase consumption, Build the data cloud
A Snowflake customer cannot be both a data provider and data consumer in the Snowflake Marketplace.
False
All the features that fall under Horizon are brand new to Snowflake's platform.
False
Executing a SQL statement as a Serverless Task costs the same as running it on a customer-controlled virtual warehouse.
False
Search Optimization Service (SOS) is standard in all Snowflake editions.
False
Search Optimization Service is ideal for unstructured data like images and sound files.
False
Snowflake includes a feature that allows it to process OLAP Cubes.
False
Snowflake storage cost is calculated based on raw data volume.
False
Snowflake's Query Acceleration Service (QAS) typically benefits most of the queries in customer workloads.
False
Snowflake's data collaboration model for sharing data across organizations is based on file transfer protocol.
False
When customers use Snowpipe, cloud storage locations are monitored for new files, and when they arrive, data engineers load them into Snowflake tables.
False
When using materialized views, changes to the base table get merged into the materialized view at no additional cost.
False
With Cross-Cloud Auto-Fulfillment, providers have to run a number of queries and steps to ensure that the content is refreshed.
False
Our core platform differentiators that we use to compete are compiled in the ________ framework.
GUEST
Customers who rely on location-based data and want to run computations on this data in Snowflake will be interested in our ______
Geospatial analytics features
Snowflake built data connectors for which of the following: (Choose 3)
Google Analytics, ServiceNow, Salesforce
Which of the following are elements of the GUEST competitive differentiators framework? (Choose 3)
Governed, Easy, Sharing
What are two primary strengths of Snowflake's governance and security model? (Choose 2)
Granular permissions via role-based access control (RBAC), Controls are applied consistently regardless of access method
A new feature released with Snowflake Horizon is an out-of-the-box _____________ that you can use to tag data and protect sensitive data.
Graphical Interface
Snowflake Connectors for applications like ServiceNow and Salesforce improve data engineering by: (Choose 2)
Handling both initial and incremental loading, Simplifying data ingestion
Which of the following are the benefits of Snowflake using cloud-provider object storage services? (Choose 3)
High availability and durability, Effectively limitless capacity, Low cost
Snowflake's overarching name for a broad set of security and governance features is called ________.
Horizon
Which are the two biggest drivers of Snowflake compute cost? (Choose 2)
How long the virtual warehouse was up, Virtual warehouse size
Snowflake's Time-Series features help with: (Choose 3)
Identifying trends and anomalies in the data, Data associated with a timestamp, Tracking key metrics over time
Which of the following best describes how Snowflake's multi-cluster shared data architecture contributes to better scalability and performance?
It dedicates elastic compute resources to users, groups, or applications
Geospatial analytics are challenging because:
Location data typically uses specialized data types and functions
A key part of Snowflake's ease-of-use story comes from leveraging
Managed services
Snowflake's __________ feature allows users to discover, access, and share governed data with internal teams or external partners, streamlining the process of collaborating on data projects and enabling more efficient decision-making.
Marketplace
Snowflake's cloud services layer uses _______________ to improve query performance, track data lineage, and manage compute resources.
Metadata
What aspects of Snowflake come into play when considering query performance on very large data sets? (Choose 2)
Micro partitions, Clustering
What is the ability to add pricing plans to a data listing called?
Monetization
What is the main characteristic that distinguishes Snowpark-optimized virtual warehouses from standard ones?
More RAM on the virtual warehouse
Snowpipe's key features are: (Choose 3)
Near real-time data ingestion, Serverless architecture, Cost effective
When sharing data between two Snowflake accounts in the same cloud provider, how much delay is there before a data change is visible in the account that data is being shared to?
None
Which of the following is not a component of Snowflake's architecture?
OLAP cube service
Which semi-structured file formats are supported in Snowflake? (Choose 2)
Parquet, JSON
Which of the following are languages that Snowpark works with? (Choose 2)
Python, Scala
Snowflake can speed up some queries by temporarily adding more compute resources to a virtual warehouse. What do we call this feature?
Query Acceleration Service (QAS)
Which term refers to Snowflake's framework for managing access to database objects?
Role-based access control (RBAC)
Snowflake Serverless Tasks allow users to schedule an execution of a __________ without needing to choose a virtual warehouse.
SQL statement
Snowflake's unified data platform and managed services provide comprehensive _______________ controls that are universally enforced regardless of region or cloud.
Security and governance
Snowflake's Data Clean Rooms (DCRs) allow for __________
Sharing and analyzing data in a privacy-preserving way
What is the purpose of the Snowflake data sharing feature?
Sharing data across different Snowflake accounts
The __________________ allows companies to list their data products publicly with the possibility of leveraging on-platform monetization.
Snowflake Marketplace
Which three of these terms are typically associated with Snowflake Collaboration? (Choose 3)
Snowflake Marketplace, Auto-fulfillment, Listings
What is one advantage of using a Serverless Task?
Snowflake automatically manages compute resources
Easy is an element of the GUEST competitive differentiator framework because ____________
Snowflake manages availability, upgrades, security, and instant elasticity automatically.
Snowflake's Data Cloud allows sharing across organizations and cloud regions/providers via
Snowgrid
__________ is the part of Snowflake's architecture that makes capabilities like account and database replication possible.
Snowgrid
Before _____________, customers would transfer data out of Snowflake to run Python or Scala code.
Snowpark
_____________ allows customers to use non-SQL languages to benefit from the power of Snowflake's compute resources.
Snowpark
___________ allows customers to deploy their own applications into a fully managed environment within Snowflake.
Snowpark Container Services
Which of these Snowflake features are considered "serverless"?
Snowpipe
What is a data share that has produced at least 20 transactions in which compute resources are consumed and such consumption results in recognized product revenue over two successive, three-week periods (with at least 20 transactions in each period)?
Stable Edge
What two types of data does Snowflake manage natively?
Structured and semi-structured data
Which of the following describes a core tenet of Snowflake's design?
Take advantage of abundant cloud provider compute and storage resources
Which two key elements make up the Snowflake Data Cloud?
The Snowflake single global platform and the content managed in it
What does a materialized view database object contain?
The result of a query
What are some of the problems with traditional sharing methods such as APIs, ETL, and FTP that are solved by using Snowflake's collaboration features? (Choose 3)
Time and cost involved in building then maintaining these mechanisms, Data is often out of date, Complex to secure
Any data that is collected over time and has a timestamp associated with it is considered ________data.
Time-series
Query Acceleration Service can make ML use cases faster and more cost-effective.
True
Snowflake's geospatial feature helps with advanced analytics because it supports various geospatial functions and data types.
True
Snowflake's support for diverse types of data means customers can often consolidate multiple data platforms into Snowflake.
True
Snowpipe enables near-real-time ingestion and processing of streaming data.
True
The Snowflake Data Cloud is the same as the Snowflake platform.
True
The Snowflake Marketplace is growing faster than our competitors' offerings.
True
Which three of the following are some advantages of using the Snowflake Marketplace's monetization features? (Choose 3)
Usage or subscription-based pricing models, Unified procurement through Snowflake, Choice of public or private listings
What are two ways that Snowflake can manage and interact with unstructured data?
User-defined functions and directory tables
Snowflake's Search Optimization Service is meant to help in cases where customers need __________.
Very fast response on point lookup queries
