Final Exam: The Snowflake Data Platform
Snowflake | Beginner
- 1 video | 32s
- Includes Assessment
- Earns a Badge
Final Exam: The Snowflake Data Platform will test your knowledge and application of the topics presented throughout the The Snowflake Data Platform track of the Skillsoft Aspire Data Infrastructure Journey.
WHAT YOU WILL LEARN
Recognize the technology of the snowflake data platformoutline snowflake's architecturerecall the different features of snowflake editionsidentify how snowflake's pricing model worksrecall how virtual warehouses workuse the snowsight uidifferentiate permanent, temporary, and transient tablesuse transient tablesuse permanent and temporary tablesrestore dropped tablesdownload and set up snowsql on macdownload and set up snowsql on windowsdefine and use variables in snowsqlrecognize internal and external stages in snowflakerecall how user, named, and table stages workidentify how user, named, and table stages workuse named stagesuse table stages and validation moderecall how external stages work in snowflakerecall how to integrate snowflake with google cloud platform (gcp)create a gcs bucketconfigure gcp permissionsrecall how to integrate snowflake with azurerecognize how to unload data in snowflakeunload data to google cloud storage bucketsunload data to user stagesunload data to azure blob storage containersload data into tablesuse retrieval optimization in snowflakeexplore how to disable caching
explore the concept of clustering in snowflakesuspend clusteringenable search optimizationexplore and enable search optimizationcreate non-materialized viewscreate and use materialized viewsuse secure viewsrecognize how the snowpipe service works in snowflakecreate a snowpipe and view its metadatacreate a snowflake storage integration to set up a simple storage service (s3) bucket as an external stageset up an amazon web services (aws) integration and access management (iam) role for the ingestion of data into snowflakelink the azure and snowflake resources with a snowpipe for continuous data ingestionperform inner, left, and right joinsexecute full outer, natural, and cross joinsrecall how windowing functions work in snowflakedescribe how windowing functions work in snowflakeuse subqueries and set operatorsrecall how structured and semi-structured data workload json data into an internal snowflake stageextract column values from json data and load them into a regular snowflake tablequery xml data and flatten out hierarchical datarecall how to configure security in snowflakedescribe how to configure security in snowflakecreate and use resource monitorsset up okta for sso for snowflakeidentify how secure data sharing works in snowflakeset up a secure share of snowflake objects between two accountsdownload and use data from snowflake marketplacerecall how to access shared provider data in a consumer accountaccess shared provider data in a consumer account
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.