This Mock Exam will validate knowledge to apply specific core expertise implementing and migrating to Snowflake. A SnowPro Core Certified individual has a thorough understanding of the Snowflake Cloud Data Platform, and has the knowledge necessary to develop, and manage secure, scalable Snowflake solutions to drive business objectives. The candidate is expected to have knowledge of: Data Loading and Transformation in Snowflake Virtual Warehouse Performance and Concurrency DDL and DML Queries Using Semi-Structured and Unstructured Data Cloning and Time Travel Data Sharing Snowflake Account Structure and ManagementSNOWPRO CORE DOMAINS & OBJECTIVESThis Mock Exam outline includes test domains, weightings, and objectives. Domain 1.0: Snowflake Cloud Data Platform Features and Architecture1.1 Outline key features of the Snowflake Cloud Data Platform. Elastic Storage Elastic Compute Snowflakes three distinct layers Data Cloud/ Data Exchange/ Partner Network Cloud partner categories1.2 Outline key Snowflake tools and user interfaces. Snowflake User Interfaces (UI) Snowsight Snowflake connectors Snowflake drivers SQL scripting Snowpark1.3 Outline Snowflakes catalog and objects. Databases Schemas Tables Types View Types Data types User-Defined Functions (UDFs) and User Defined Table Functions (UDTFs) Stored Procedures Streams Tasks Pipes Shares Sequences1.4 Outline Snowflake storage concepts. Micro partitions Types of column metadata clustering Data Storage Monitoring Search Optimization ServiceDomain 2.0: Account Access and Security2.1 Outline security principles. Network security and policies Multi-Factor Authentication (MFA) Federated authentication Single Sign-On (SSO)2.2 Define the entities and roles that are used in Snowflake. Outline how privileges can be granted and revoked Explain role hierarchy and privilege inheritance2.3 Outline data governance capabilities in Snowflake. Accounts Organizations Databases Secure views Information schemas Access history and read supportDomain 3.0: Performance Concepts3.1 Explain the use of the Query Profile. Explain plans Data spilling Use of the data cache Micro-partition pruning Query history3.2 Explain virtual warehouse configurations. Multi-clustering Warehouse sizing Warehouse settings and access3.3 Outline virtual warehouse performance tools. Monitoring warehouse loads Query performance Scaling up compared to scaling out Resource monitors3.4 Optimize query performance. Describe the use of materialized views Use of specific SELECT commandsDomain 4.0: Data Loading and Unloading4.1 Define concepts and best practices that should be considered when loading data. Stages and stage types File size File formats Folder structures Adhoc/bulk loading using the Snowflake UI4.2 Outline different commands used to load data and when they should be used. CREATE PIPE COPY INTO GET INSERT/INSERT OVERWRITE PUT STREAM TASK VALIDATE4.3 Define concepts and best practices that should be considered when unloading data. File formats Empty strings and values Unloading to a single file Unloading relational tables4.4 Outline the different commands used to unload data and when they should be used. LIST COPY INTO CREATE FILE FORMAT CREATE FILE FORMAT CLONE ALTER FILE FORMAT DROP FILE FORMAT DESCRIBE FILE FORMAT SHOW FILE FORMATDomain 5.0: Data Transformations5.1 Explain how to work with standard data. Estimating functions Sampling Supported function types User-Defined Functions (UDFs) and stored procedures5.2 Explain how to work with semi-structured data. Supported file formats, data types, and sizes VARIANT column Flattening the nested structure5.3 Explain how to work with unstructured data. Directory tables SQL file functions Rest API Create User-Defined Functions (UDFs) for data analysisDomain 6.0: Data Protection and Data Sharing6.1 Outline Continuous Data Protection with Snowflake. Time Travel Fail-safe Data Encryption Cloning Replication6.2 Outline Snowflake data sharing capabilities. Account types Data Marketplace and Data Exchange Private data exchange Access control options Shares
