From the course: Snowflake SnowPro Core Cert Prep
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Domain 2.0: Recap - Snowflake Tutorial
From the course: Snowflake SnowPro Core Cert Prep
Domain 2.0: Recap
So let's recap what we've been through in Domain 2. So MFA, you can configure it for the Web UI, JDBC and SnowSQL. Snowflake encrypts all customer data by default using the latest security standards, at no additional cost. Enterprise edition is the lowest level that provides column-level security. RBAC means that access privileges are assigned to roles, which are in turn assigned to users. The account administrator role is the most powerful one within the Snowflake environment out of the box, and that role alone is responsible for configuring any parameters at the account level. Secure views should not be used for views that are defined for query convenience, such as views for simplifying querying data for which users do not need to understand the online data representation because of the performance downside. There's five standard roles out of the box in addition to ORGADMIN in Snowflake. They are: ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, PUBLIC, and USERADMIN. The GRANTS_TO_ROLES…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.