{"id":1649,"date":"2019-08-06T10:19:23","date_gmt":"2019-08-06T10:19:23","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=1649"},"modified":"2020-05-02T05:47:59","modified_gmt":"2020-05-02T05:47:59","slug":"amazon-redshift","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/","title":{"rendered":"Amazon Redshift"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>It is a fast, scalable data warehouse <\/li><li>Used to analyze all data across data warehouse\nand data lake. <\/li><li>Integrates with machine learning, parallel query\nexecution, and columnar storage. <\/li><li>Setup and deploy a new data warehouse in minutes<\/li><li>Run queries across petabytes in Redshift, and\nexabytes in data lake.<\/li><li>uses columnar storage, data compression, and\nzone maps to reduce I\/O to perform queries.<\/li><li>Has a massively parallel processing (MPP)\narchitecture to parallelize and distribute SQL operations <\/li><li>stores three copies of your data \u2014 all data\nwritten to a node in cluster is automatically replicated to other nodes within\nthe cluster, and all data is continuously backed up to Amazon S3.<\/li><li>Snapshots are automated, incremental, and\ncontinuous and stored for a user-defined period (1-35 days)<\/li><li>Manual snapshots can be created and are retained\nuntil deleted.<\/li><li>Continuously monitors health of cluster <\/li><li>Automatically re-replicates data from failed\ndrives and replaces nodes as necessary.<\/li><li>has three pricing components:<ul><li>data\nwarehouse node hours \u2013 total number of hours run across all the compute node<\/li><\/ul><ul><li>backup\nstorage \u2013 storage cost for automated and manual snapshots<\/li><\/ul><ul><li>data\ntransfer<ul><li>There\nis no data transfer charge for data transferred to or from Amazon Redshift\noutside of Amazon VPC<\/li><\/ul><ul><li>Data\ntransfer to or from Amazon Redshift in Amazon VPC accrues standard AWS data\ntransfer charges.<\/li><\/ul><\/li><\/ul><\/li><li>number of nodes can be easily scaled as per\ndemand<\/li><\/ul>\n\n\n\n<p><strong>Monitoring Amazon RDS <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon RDS Events \u2013 Subscribe to Amazon RDS\nevents to be notified when changes occur with a DB instance, DB cluster, DB\nsnapshot, DB cluster snapshot, DB parameter group, or DB security group. <\/li><li>Database log files \u2013 View, download, or watch\ndatabase log files using the Amazon RDS console or Amazon RDS API actions. You\ncan also query some database log files that are loaded into database tables. <\/li><li>Amazon RDS Enhanced Monitoring \u2014 Look at metrics\nin real time for the operating system that your DB instance or DB cluster runs\non.<\/li><li>Amazon CloudWatch Metrics \u2013 Amazon RDS\nautomatically sends metrics to CloudWatch every minute for each active database\ninstance and cluster. <\/li><li>Amazon CloudWatch Alarms \u2013 Watch a single Amazon\nRDS metric over a specific time period, and perform actions based on the value\nof the metric relative to a threshold you set. <\/li><li>Amazon CloudWatch Logs \u2013 MariaDB, MySQL, and\nAurora MySQL enable you to monitor, store, and access your database log files\nin CloudWatch Logs.<\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is a fast, scalable data warehouse Used to analyze all data across data warehouse and data lake. Integrates with machine learning, parallel query execution, and columnar storage. Setup and deploy a new data warehouse in minutes Run queries across petabytes in Redshift, and exabytes in data lake. uses columnar storage, data compression, and zone&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":383,"menu_order":16,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[218,7],"class_list":["post-1649","page","type-page","status-publish","hentry","tag-amazon-rds","tag-aws"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Amazon Redshift - Testprep Training Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amazon Redshift - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"It is a fast, scalable data warehouse Used to analyze all data across data warehouse and data lake. Integrates with machine learning, parallel query execution, and columnar storage. Setup and deploy a new data warehouse in minutes Run queries across petabytes in Redshift, and exabytes in data lake. uses columnar storage, data compression, and zone...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-02T05:47:59+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/\",\"name\":\"Amazon Redshift - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-08-06T10:19:23+00:00\",\"dateModified\":\"2020-05-02T05:47:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Certified SysOps Administrator &#8211; Associate (SOA-C01)\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Amazon Redshift\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Amazon Redshift - Testprep Training Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/","og_locale":"en_US","og_type":"article","og_title":"Amazon Redshift - Testprep Training Tutorials","og_description":"It is a fast, scalable data warehouse Used to analyze all data across data warehouse and data lake. Integrates with machine learning, parallel query execution, and columnar storage. Setup and deploy a new data warehouse in minutes Run queries across petabytes in Redshift, and exabytes in data lake. uses columnar storage, data compression, and zone...","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-05-02T05:47:59+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/","name":"Amazon Redshift - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-08-06T10:19:23+00:00","dateModified":"2020-05-02T05:47:59+00:00","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/amazon-redshift\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"AWS Certified SysOps Administrator &#8211; Associate (SOA-C01)","item":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-sysops-administrator-associate\/"},{"@type":"ListItem","position":3,"name":"Amazon Redshift"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=1649"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1649\/revisions"}],"predecessor-version":[{"id":1651,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/1649\/revisions\/1651"}],"up":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/383"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=1649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=1649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=1649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}