Snowflake Ecosystem for the SnowPro Core Certification
Chapter 20: Snowflake Ecosystem, Compliance, Data Marketplace & Security
We are arriving at the end of the Snowflake SnowPro Core Certification course. This is going to be the last theoretical chapter of the course, where we are going to study the following concepts:
- Snowflake Ecosystem
- Snowflake Compliance
- Snowflake Data Marketplace
- Snowflake Column Level Security
- Typical Exam Questions
Remember that you can find all the chapters from the course at the following link:
SNOWFLAKE ECOSYSTEM
Partner Connect → Lets you easily create trial accounts with selected Snowflake business partners and integrate them with Snowflake to try various 3rd-party tools and services. There are two types of partners:
- Technology partners → They integrate their solutions with Snowflake to get data quickly into Snowflake. They offer Software, driver, interfaces…
- Solution partners → Trusted and validated experts and services. They are like consulting partners.
These partners are classified into six different categories, as shown in the previous image:
- Data Integration
- ML & Data Science
- Security & Governance
- Business Intelligence
- SQL Editors
- Programming Interfaces
SNOWFLAKE COMPLIANCE
This is the list of reports available on Snowflake. You can get more information about them at the following link. I’ve pointed out the most important ones, although I don’t think you will be asked in-depth questions about them in the exam. Just remember the names.
- HITRUST / HIPAA
- ISO/IEC 27001
- FedRAMP Moderate
- PCI-DSS
- SOC 2 Type II
- SOC 1 Type II
- GxP
SNOWFLAKE DATA MARKETPLACE
In the data marketplace, you can buy or sell data provided by providers who share their datasets.
There are three types of listings available in the Snowflake Data Marketplace:
- Free Listing → Also known as Standard Listing. It’s the best for providing generic, aggregated, or non-customer-specific data.
- Personalized Listing → Premium data. You can request specific datasets from providers.
- Paid Listing → As a provider, you can charge consumers to access or use your listing.
There is also another type of listing, the Private Listing. However, it’s not available in the Data Marketplace. With them, you can use listings to share data and other information directly with another Snowflake account.
Let’s make an example. Imagine you want to use a dataset about the weather, and there is a company providing that. The standard option could be to download this dataset once a day. The personalized option might be to ask for the New York weather every 5 minutes. This is a request you have to make to the provider.
As we mentioned, we can also upload our datasets to the Snowflake Marketplace. To do that, our dataset must meet these conditions:
- Fresh data
- Non-static data
- Real data
- Compliant data
- Legally Distributable data
COLUMN LEVEL SECURITY
Snowflake provides the following column-level security features for users with at least Enterprise Edition:
- Dynamic Data Masking → Column-level Security feature that uses masking policies to mask data at query time. You can hide some columns for users with a lower role.
- External Tokenization → You can tokenize sensitive data before loading it into Snowflake. You can also detokenize it using masking policies. It’s useful for data like passwords or any sensitive data.
TYPICAL EXAM QUESTIONS
Which certifications are compliant with Snowflake?
- HIPAA
- PCI-DSS
- FedRAMP
Solution: 1, 2, 3.
Can Snowflake perform transformations after loading files staged by partner software (ELT)?
- True
- False
Solution: 1.
Column-level security in Snowflake allows the application of a masking policy to a column within a table or view. Which two features are related to column-level security?
- Dynamic Data Masking
- Lock Databases
- External Tokenization
Solution: 1, 3.
What is common between Fivetran, Informatica, Stitch, and Talend?
- They are Snowflake programming interfaces partners
- They are Snowflake data integration partners
- They are Snowflake security partners
Solution: 2.
Thanks for Reading!
If you like my work and want to support me:
- The BEST way is to follow me on Medium here.
- Feel free to clap if this post is helpful for you! :)
- More Snowflake SnowPro Core practice exam questions? Find them at FullCertified.com!
