{"product_id":"sybexs-study-guide-for-snowflake-snowpro-core-certification-9781119824442","title":"Sybexs Study Guide for Snowflake SnowPro Core","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction xxi\u003c\/p\u003e \u003cp\u003eAssessment Test xxxiii\u003c\/p\u003e \u003cp\u003eAnswers to Assessment Test xxxviii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introduction and Overview 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Snowflake 2\u003c\/p\u003e \u003cp\u003eSnowflake Journey 3\u003c\/p\u003e \u003cp\u003eSnowflake Certifications 3\u003c\/p\u003e \u003cp\u003eSigning Up for a Snowflake Trial 5\u003c\/p\u003e \u003cp\u003eSummary 13\u003c\/p\u003e \u003cp\u003eExam Essentials 14\u003c\/p\u003e \u003cp\u003eReview Questions 15\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Snowflake Architecture 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTraditional Database Architectures 18\u003c\/p\u003e \u003cp\u003eSnowflake’s Hybrid Architecture 19\u003c\/p\u003e \u003cp\u003eThe Three Layers of Snowflake Architecture 20\u003c\/p\u003e \u003cp\u003eThe Database Storage Layer: Micro-Partitions and Clustering 22\u003c\/p\u003e \u003cp\u003eThe Query Processing Layer: The Concept of a Virtual\u003c\/p\u003e \u003cp\u003eWarehouse 26\u003c\/p\u003e \u003cp\u003eConfiguring a Virtual Warehouse 30\u003c\/p\u003e \u003cp\u003eSummary 32\u003c\/p\u003e \u003cp\u003eExam Essentials 33\u003c\/p\u003e \u003cp\u003eReview Questions 34\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Interfaces and Connectivity 39\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSnowflake Web UI 40\u003c\/p\u003e \u003cp\u003eWeb Interface Components 41\u003c\/p\u003e \u003cp\u003eSnowflake Partners 46\u003c\/p\u003e \u003cp\u003eSnowflake Connectors and Drivers 46\u003c\/p\u003e \u003cp\u003eUser Defined Functions 47\u003c\/p\u003e \u003cp\u003eSnowSQL 47\u003c\/p\u003e \u003cp\u003eNew Snowflake Web Interface 50\u003c\/p\u003e \u003cp\u003eSummary 53\u003c\/p\u003e \u003cp\u003eExam Essentials 53\u003c\/p\u003e \u003cp\u003eReview Questions 54\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Loading Data 57\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Loading in Snowflake 59\u003c\/p\u003e \u003cp\u003eSupported File Formats for Loading Data 60\u003c\/p\u003e \u003cp\u003eCompression 60\u003c\/p\u003e \u003cp\u003eEncryption 60\u003c\/p\u003e \u003cp\u003eWhat Is a Stage? 61\u003c\/p\u003e \u003cp\u003eExternal Stage 62\u003c\/p\u003e \u003cp\u003eInternal Stages 62\u003c\/p\u003e \u003cp\u003eData Loading via Internal Stages 64\u003c\/p\u003e \u003cp\u003eLoading On-premises Data via the Table Stage 64\u003c\/p\u003e \u003cp\u003eLoading On-premises Data via the User Stage 67\u003c\/p\u003e \u003cp\u003eLoading On-premises Data via the Named Internal Stage 70\u003c\/p\u003e \u003cp\u003eData Ingestion Using the Named External Stage 73\u003c\/p\u003e \u003cp\u003eLoading Data from Cloud Storage via the External Stage 74\u003c\/p\u003e \u003cp\u003eLoading Data via the Snowflake Web UI 75\u003c\/p\u003e \u003cp\u003eBasic Data Transformations While Ingesting 77\u003c\/p\u003e \u003cp\u003eExternal Tables 79\u003c\/p\u003e \u003cp\u003eSemi-Structured Data 81\u003c\/p\u003e \u003cp\u003eThe \u003ci\u003eVARIANT \u003c\/i\u003eData Type and Semi-Structured Data 81\u003c\/p\u003e \u003cp\u003eLoading NDJSON Data 82\u003c\/p\u003e \u003cp\u003eLoading JSON Data 85\u003c\/p\u003e \u003cp\u003eUnloading Data from Snowflake 88\u003c\/p\u003e \u003cp\u003eFile Formats Supported for Unloading 89\u003c\/p\u003e \u003cp\u003eCompression 89\u003c\/p\u003e \u003cp\u003eEncryption 90\u003c\/p\u003e \u003cp\u003eUnload Data to an On-premises System via an Internal Stage 90\u003c\/p\u003e \u003cp\u003eLoad Near-Real- Time Streaming Data 91\u003c\/p\u003e \u003cp\u003eHow Snowpipe Works 92\u003c\/p\u003e \u003cp\u003eOptimizing Data Loading and Unloading 93\u003c\/p\u003e \u003cp\u003eBulk Load Optimization 93\u003c\/p\u003e \u003cp\u003eOptimizing Snowpipe Loads 93\u003c\/p\u003e \u003cp\u003eOptimizing Data Unloading 93\u003c\/p\u003e \u003cp\u003eSummary 94\u003c\/p\u003e \u003cp\u003eExam Essentials 94\u003c\/p\u003e \u003cp\u003eReview Questions 95\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Data Pipelines 99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Tasks 100\u003c\/p\u003e \u003cp\u003eScheduling a Task 100\u003c\/p\u003e \u003cp\u003eConnecting Multiple Tasks in a Task Tree 104\u003c\/p\u003e \u003cp\u003eUser-Managed and Serverless Tasks 107\u003c\/p\u003e \u003cp\u003eIntroducing Streams 110\u003c\/p\u003e \u003cp\u003eCapture Changes Using Streams 110\u003c\/p\u003e \u003cp\u003eSummary 114\u003c\/p\u003e \u003cp\u003eExam Essentials 114\u003c\/p\u003e \u003cp\u003eReview Questions 115\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Continuous Data Protection 117\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eComponents of Continuous Data Protection 118\u003c\/p\u003e \u003cp\u003eData Encryption 118\u003c\/p\u003e \u003cp\u003eAccess Control 118\u003c\/p\u003e \u003cp\u003eNetwork Policies 119\u003c\/p\u003e \u003cp\u003eTime Travel 119\u003c\/p\u003e \u003cp\u003eFail-safe 119\u003c\/p\u003e \u003cp\u003eTime Travel and Fail-safe 119\u003c\/p\u003e \u003cp\u003eTime Travel in Action 122\u003c\/p\u003e \u003cp\u003eUndrop Using Time Travel 127\u003c\/p\u003e \u003cp\u003eTime Travel and Fail-Safe Storage Costs 128\u003c\/p\u003e \u003cp\u003eTemporary Tables 129\u003c\/p\u003e \u003cp\u003eTransient Tables 129\u003c\/p\u003e \u003cp\u003eSummary 129\u003c\/p\u003e \u003cp\u003eExam Essentials 130\u003c\/p\u003e \u003cp\u003eReview Questions 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Cloning and Data Sharing 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eZero-Copy Cloning 134\u003c\/p\u003e \u003cp\u003eHow Zero-Copy Cloning Works 135\u003c\/p\u003e \u003cp\u003eDatabase, Schema, and Table Cloning 138\u003c\/p\u003e \u003cp\u003eCloning with Time Travel 142\u003c\/p\u003e \u003cp\u003eSecure Data Sharing in Snowflake 143\u003c\/p\u003e \u003cp\u003eDirect Sharing 144\u003c\/p\u003e \u003cp\u003eSnowflake Data Marketplace 150\u003c\/p\u003e \u003cp\u003eData Exchange 151\u003c\/p\u003e \u003cp\u003eSummary 152\u003c\/p\u003e \u003cp\u003eExam Essentials 152\u003c\/p\u003e \u003cp\u003eReview Questions 154\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Performance 157\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSnowflake Performance Considerations 158\u003c\/p\u003e \u003cp\u003eVirtual Warehouse Configuration 160\u003c\/p\u003e \u003cp\u003eVirtual Warehouse Scaling Up and Down 160\u003c\/p\u003e \u003cp\u003eScaling Out Using Multi-cluster Virtual Warehouses 161\u003c\/p\u003e \u003cp\u003eCaching in Snowflake 164\u003c\/p\u003e \u003cp\u003eMetadata Cache 165\u003c\/p\u003e \u003cp\u003eQuery Result Cache 166\u003c\/p\u003e \u003cp\u003eVirtual Warehouse Cache 167\u003c\/p\u003e \u003cp\u003eMicro-partition Pruning 168\u003c\/p\u003e \u003cp\u003eMicro-partitions and Data Clustering 169\u003c\/p\u003e \u003cp\u003eWhat Happens Behind the Scenes 169\u003c\/p\u003e \u003cp\u003eClustering Keys 170\u003c\/p\u003e \u003cp\u003eSearch Optimization 171\u003c\/p\u003e \u003cp\u003eMaterialized Views 171\u003c\/p\u003e \u003cp\u003eSummary 172\u003c\/p\u003e \u003cp\u003eExam Essentials 173\u003c\/p\u003e \u003cp\u003eReview Questions 175\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Security 179\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Encryption at Rest 180\u003c\/p\u003e \u003cp\u003eKey Rotation and Rekeying 181\u003c\/p\u003e \u003cp\u003eTri-Secret Secure 181\u003c\/p\u003e \u003cp\u003eAuthentication 181\u003c\/p\u003e \u003cp\u003eMultifactor Authentication (MFA) 181\u003c\/p\u003e \u003cp\u003eKey Pair Authentication 183\u003c\/p\u003e \u003cp\u003eSSO via SAML 2.0 Federated Authentication 183\u003c\/p\u003e \u003cp\u003ePassword Policies 183\u003c\/p\u003e \u003cp\u003eUser Provisioning Through SCIM 184\u003c\/p\u003e \u003cp\u003eAuthorization 184\u003c\/p\u003e \u003cp\u003eAccess Control in Snowflake 185\u003c\/p\u003e \u003cp\u003eColumn-Level Security 188\u003c\/p\u003e \u003cp\u003eRow-Level Security 188\u003c\/p\u003e \u003cp\u003eSecure Views and Secure UDFs 189\u003c\/p\u003e \u003cp\u003eUser Access Audit Log 189\u003c\/p\u003e \u003cp\u003eNetwork 189\u003c\/p\u003e \u003cp\u003eNetwork Policies 189\u003c\/p\u003e \u003cp\u003eSupport for Private Connectivity 190\u003c\/p\u003e \u003cp\u003eEncryption for All Communication 190\u003c\/p\u003e \u003cp\u003eCompliance with Standards 190\u003c\/p\u003e \u003cp\u003eSummary 191\u003c\/p\u003e \u003cp\u003eExam Essentials 192\u003c\/p\u003e \u003cp\u003eReview Questions 194\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Account and Resource Management 197\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eResource Monitors 198\u003c\/p\u003e \u003cp\u003eSystem Usage and Billing 205\u003c\/p\u003e \u003cp\u003eThe ACCOUNT_USAGE Schema 206\u003c\/p\u003e \u003cp\u003eThe INFORMATION_SCHEMA Schema 209\u003c\/p\u003e \u003cp\u003eSnowflake Releases 214\u003c\/p\u003e \u003cp\u003ePhased Release Process for Full Releases 214\u003c\/p\u003e \u003cp\u003eSummary 214\u003c\/p\u003e \u003cp\u003eExam Essentials 215\u003c\/p\u003e \u003cp\u003eReview Questions 216\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix Answers to the Review Questions 219\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introduction and Overview 220\u003c\/p\u003e \u003cp\u003eChapter 2: Snowflake Architecture 220\u003c\/p\u003e \u003cp\u003eChapter 3: Interfaces and Connectivity 222\u003c\/p\u003e \u003cp\u003eChapter 4: Loading Data 224\u003c\/p\u003e \u003cp\u003eChapter 5: Data Pipelines 226\u003c\/p\u003e \u003cp\u003eChapter 6: Continuous Data Protection 226\u003c\/p\u003e \u003cp\u003eChapter 7: Cloning and Data Sharing 227\u003c\/p\u003e \u003cp\u003eChapter 8: Performance 229\u003c\/p\u003e \u003cp\u003eChapter 9: Security 231\u003c\/p\u003e \u003cp\u003eChapter 10: Account and Resource Management 232\u003c\/p\u003e \u003cp\u003eIndex 235\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49407163695447,"sku":"9781119824442","price":38.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119824442.jpg?v=1730498393","url":"https:\/\/bookcurl.com\/products\/sybexs-study-guide-for-snowflake-snowpro-core-certification-9781119824442","provider":"Book Curl","version":"1.0","type":"link"}