13.6.1: Review Questions
- Page ID
- 58353
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\dsum}{\displaystyle\sum\limits} \)
\( \newcommand{\dint}{\displaystyle\int\limits} \)
\( \newcommand{\dlim}{\displaystyle\lim\limits} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\(\newcommand{\longvect}{\overrightarrow}\)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\ket}[1]{\left| #1 \right>}\)
\(\newcommand{\bra}[1]{\left< #1 \right|}\)
\(\newcommand{\braket}[2]{\left< #1 \vphantom{#2} \right| \left. #2 \vphantom{#1} \right>}\)
\(\newcommand{\braopket}[3]{\left< #1 \vphantom{#2}\vphantom{#3} \right| #2 \vphantom{#1}\vphantom{#3} \left| #3 \vphantom{#1}\vphantom{#2} \right>}\)
\(\newcommand{\qmvec}[1]{\mathbf{\vec{#1}}}\)
\(\newcommand{\op}[1]{\hat{\mathbf{#1}}}\)
\(\newcommand{\expect}[1]{\langle #1 \rangle}\)
\(\newcommand{\dfn}[1]{\emph{\textbf{#1}}}\)
Review Questions
Multiple Choice
-
Which cloud analytics service is serverless, charges per query based on data scanned, and runs SQL directly on S3?
-
a) Amazon Redshift b) Amazon Athena c) Azure Synapse d) Amazon QuickSight
-
-
HSBC's cloud migration to Google Cloud for risk modeling achieved approximately:
-
a) 2x faster analysis b) 5x faster analysis c) 16x faster analysis d) 100x faster analysis
-
-
Which cost optimization strategy involves using spare cloud capacity at steep discounts for fault-tolerant batch jobs?
-
a) Reserved instances b) On-demand pricing c) Spot/preemptible instances d) Storage tiering
-
Short Answer
-
Compare AWS Redshift, Google BigQuery, and Azure Synapse. How does each approach compute and storage? Which uses a truly serverless model?
-
Describe the four-layer serverless analytics architecture (ingest → store → process → serve). Give specific AWS services for each layer.
-
Explain three cost optimization strategies for cloud analytics. For each, describe the trade-off (e.g., cost savings vs. flexibility or risk).
-
What is vendor lock-in in cloud analytics, and how can organizations mitigate it? Describe two specific strategies.
True/False
-
True or False: Amazon Athena requires you to provision and manage server clusters before running queries.
-
True or False: A manufacturing company using Azure IoT + ML for predictive maintenance achieved a 40% reduction in unplanned downtime.
-
True or False: Using open-source frameworks like Apache Beam helps reduce vendor lock-in by enabling portable data pipelines.
Answer Key:
1-b, 2-c, 3-c, 4. Redshift: provisioned clusters (or serverless option), columnar MPP warehouse. BigQuery: fully serverless, separates compute/storage, pay per query data scanned — most serverless. Synapse: hybrid — offers both dedicated SQL pools (provisioned) and serverless on-demand query. BigQuery is the most purely serverless. 5. Ingest: Kinesis/Firehose (streaming), Glue (batch ETL). Store: S3 data lake (raw/clean/curated zones). Process: Glue/Athena/EMR for transformation and analysis. Serve: QuickSight dashboards, Redshift for heavy queries, APIs for applications. 6. (1) Reserved instances: 30-72% savings but requires 1-3yr commitment — less flexibility. (2) Spot instances: 70-90% savings but can be terminated — only for fault-tolerant jobs. (3) Storage tiering: moves cold data to cheaper tiers (Glacier) — saves 68-95% but retrieval is slower. 7. Lock-in = dependence on proprietary services makes switching costly. Strategies: (1) Use open-source tools (Spark, Beam, Kubernetes) for portability across clouds. (2) Store data in vendor-neutral formats (Parquet, CSV) and avoid deeply proprietary features where possible. 8. False, 9. True, 10. True.


