{"id":1133,"date":"2024-11-19T02:19:31","date_gmt":"2024-11-19T02:19:31","guid":{"rendered":"https:\/\/192.168.1.3\/wordpress\/?p=1133"},"modified":"2024-12-18T00:29:03","modified_gmt":"2024-12-18T00:29:03","slug":"aws-certified-data-engineer-associate-dea-c01-review-material-quicksight","status":"publish","type":"post","link":"https:\/\/mylinuxsite.com\/wordpress\/?p=1133","title":{"rendered":"AWS Certified Data Engineer Associate (DEA-C01) Review Material \u2013 QuickSight"},"content":{"rendered":"\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights.<\/li><li>Used for data visualization, reporting, dashboard, anomaly detection, forecast, and insights.<\/li><li>It can connect to data in the cloud and combine data from many different sources.&nbsp;<\/li><li>It can&nbsp;scale from 10 users to 10,000, all with no infrastructure to deploy or manage.<\/li><li>It saves prepared data either in <strong>SPICE<\/strong> memory or as a direct query.<\/li><li>Supported data sources:<ul><li>Amazon Redshift\/Redshift Spectrum<\/li><li>Amazon Aurora<\/li><li>Amazon OpenSearch<\/li><li>Amazon Athena<\/li><li>Amazon S3<\/li><li>MySQL\/MariaDB\/MS SQLServer\/Postgresql\/Oracle<\/li><\/ul><\/li><li>Can connect to on-prem data sources<\/li><li><strong>SPICE:<\/strong><ul><li>A robust in-memory engine that QuickSight uses.<\/li><li>Engineered to perform advanced calculations and serve data rapidly.<\/li><li>10GB of SPICE\/user<\/li><li>You can add SPICE capacity by purchasing more SPICE.<\/li><li>Only in an <em>Enterprise edition<\/em> is data stored in SPICE encrypted at rest.<\/li><\/ul><\/li><li><strong>Security<\/strong>:<ul><li>You can use the following tools for identity and access to Amazon QuickSight:<ul><li>IAM Identity Center (<em><span style=\"color:#a30000\" class=\"has-inline-color\">Enterprise edition only<\/span><\/em>) <\/li><li>IAM federation (Standard and Enterprise editions) <\/li><li>AWS Directory Service for Microsoft Active Directory (<em>(<em><span style=\"color:#a30000\" class=\"has-inline-color\">Enterprise edition only<\/span><\/em><\/em>) <\/li><li>SAML-based single sign-on (IAM Identity Center) (Standard and Enterprise edition) <\/li><li>Multifactor authentication (MFA) (Standard and Enterprise edition)<\/li><\/ul><\/li><li>Has row and column (Enterprise edition only) level security<\/li><li>For Amazon QuickSight to access your AWS resources, you must create security groups that authorize connections from the <em>IP address ranges used by Amazon QuickSight servers.&nbsp;<\/em><\/li><li>Encryption at rest (<em>for Enterprise edition only<\/em>)<\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Infrastructure Security<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon QuickSight is delivered as a web application, hosted on dedicated Amazon EC2 hosts, separate from AWS virtual private clouds (VPCs).&nbsp;<\/li><li>Amazon QuickSight is accessed through Regional public endpoints.&nbsp;<\/li><li>The database server, which is QuickSight&#8217;s data source, must be <em>accessible from the Internet<\/em> and allow inbound traffic from QuickSight servers.<\/li><li>You can create a VPC connection in QuickSightby by adding an ENI to your VPC. This feature is available on EE only.<ul><li>This will allow cross-region or cross-account connection through:<ul><li>VPC Sharing<\/li><li>Transit Gateways<\/li><li>Private Link<\/li><\/ul><\/li><\/ul><\/li><li>For QuickSight to connect to an Amazon Redshift instance, the Amazon Redshift must have in its SG inbound rule that allows the public CIDR IP of QuickSight in that region.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Machine Learning Insights<\/strong><\/h3>\n\n\n\n<p>ML Insights is available as part of the QuickSight Enterprise Edition.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Anomaly Detection<\/strong><ul><li>Continuously analyze your data to discover anomalies and variations inside of the aggregates, giving you the insights to act when business changes occur.<\/li><li>Discovers hidden trends and outliers in your data.<\/li><li>Uses Random Cut Forrest behind the scenes.<\/li><\/ul><\/li><li><strong>Forecasting<\/strong><ul><li>Predict your business metrics and perform interactive what-if analysis with point-and-click simplicity.&nbsp;<\/li><li>Can support interactive &#8220;what-if&#8221; queries.<\/li><li>It also uses Random Cut Forrest behind the scenes.<\/li><\/ul><\/li><li><strong>Auto-narrative<\/strong><ul><li>A natural-language summary widget that displays descriptive text instead of charts.<\/li><li>Amazone Quicksights automatically interprets the charts and tables in your dashboard and provides a number of suggested insights in natural language.<\/li><\/ul><\/li><li><strong>Suggested Insights<\/strong><ul><li>Amazon QuickSight creates a list of suggested insights based on its interpretation of the data you put into your visuals.<\/li><li>You can see different suggestions depending on what fields you add to your visual and what type of visual you choose.<\/li><li>You can also create your own computation, using your own words to give context to the fields that appear in the widget through <strong>Custom Insights.<\/strong><\/li><\/ul><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-1133","post","type-post","status-publish","format-standard","hentry","category-aws-review-notes"],"_links":{"self":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1133"}],"version-history":[{"count":9,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1133\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1133\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}