Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS Cloud Practitioner > Databases & Analytics > Flashcards

Databases & Analytics Flashcards

1
Q

What is AWS RDS?

A
  • AWS Relational DatabaseS, which means that yo can query it throught SQL.
  • It is a Managed Service, SaaS.

Page 177

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What RDS Support AWS?

A

MySQL
Postgress
Oracle
MySQL
MariaDB
Ayura (AWS Owner)

(Page 177)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

AWS RDS is an administrated Service in AWS or it’s a service that you deploy into an Instance of an EC2?

A

It’s a managed Server where you can:

+ Performs Backups
+ Auto Scaling
+ Deploy them along Multiple-AZ.

It runs as SaaS

(Page 178)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

It’s possible to access RDB through SSH?

A

No, it’s not possible.

You must access them through their clients, which use their protocols.

(Page 178)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

In a Schema of Replication, its possible to write and read all over the DB?

A

No, you only are allowed to write on the MAIN DB but just read along the other replications and, by the way, the same restriction is for replications along Multi-AZ.

(page 178 and 179)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

NoSQL Database?

A

Non-Relational DB
+ Scalability
+ Basic schema
+ High Performance

(Page 174)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the Customer Responsibilities on AWS DBS when the DB is running in an EC2?

A

+ Resiliency
+ Backup
+ High Availability
+ Fault Tolerance
+ Patching
+ Scaling

It’s because the DB is not provided as SaaS.

(Page 177)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is Amazon Aurora?

A
  • It’s the implementation of MySQL/Postgress.
  • It’s Amazon’s RDB which is not OpenSource
  • It’s faster than MySQL or Postgress.

Page 180

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which feature has an RDS in common when working with replicas and multiple AZ?

A

Both of them have a Main RDS which is replicated along the AZ of its Replicant, but the replicants can only be read, providing an immediately source of data near than the main RDS. All the written transactions must be over the Main RDS.

(Page 181)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Amazon ElastiCache?

A
  • It’s an RDS on Cache (Memory) which has High performance.
  • Mount a DB on Memory (Cache)
  • Reduce load off databases for read intensive workloads
  • It’s a SaaS
  • it can be used with RDS to reduce the low laencies for writing and reading.
  • It’s a WebServices

(Page 183)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is DynamoDB?

A
  • It’s a Non-SQL DB.
  • It’s Serveless
  • Millions of request per second
  • Integrated con IAM security, autorization, and adminisration.

Page 185

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many types of tables has DynamoSB

A

Two:
* Standar
* Infrequent Access

Page 185

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is DynamoDB Accelerator - DAX?

A

DynamoDB Accelerator
It’s a service that manage a DynamoDB in cache, leveareges it to have better performance.

Page 187

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the diference between DynamoDBX & ElasticCache?

A
  • DynamoDBX only works with DynamoDB.
  • ElasticCache can be used for other BD.

Page 187

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the characteristic of a Global Table on DynamoDB?

A
  • It is replicated along Multi-AZ, and helps to redulce the low latency in AZ.
  • Any Write Opreation in a Global Table (Over an AZ) is replicated on others Global tables.

Page 188

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

OLTP?

A

OnLine Transaction Proccessing
Means: The procession is fucused to perform a transaction over the DB.

Page 189

17
Q

OLAP?

A

OnLine Analytical Proccessing
Means: The procession is fucused to perform an analysis over the DB information.

OLAP => Datawherehaus

Page 189

18
Q

What is Redshift?

A

+ BD based on Postgres
+ It’s an OLAP DB.

Page 189

19
Q

What are the main features of Redshift?

A

+ Load data every hour.
+ The data is sorted by columns and not by row.
+ can be queried by SQL.

Page 189

20
Q

What is EMR?

A

+ Amazon Elastic MapReduce
+ Helps to create Hadoop Clusters (Bigdata)
+ It can work with thousands of EC2s
+ It’s Autoscaling

Used, for example:

  • MachineLearning
  • BigData
  • Web indexeing

Page 190

21
Q

What is Hadoop?

A

A Framework to distributed large amout of information along a cluster computers.
It’s used, most of the times, to process BigData

https://hadoop.apache.org/

22
Q

What is Amazon Athena?

A

+ A services (Serveless) to Query & Analyze the content of Amazon S3.
+ Use SQL Quieres

Page 191

23
Q

What is Amazon QuickSight?

A

A service (Serveless), which provides information of several AWS, to create Dashboards.

page 192

24
Q

What is Amazon DocumentDB?

A
  • The Amazon implementation of MongoDB.
  • Store and handle JSON data.
  • IT scales automaticaly according to the workload.

page 193

25
Q

What is a Graph DB?

A
  • A DB that store Nodes and Links (Relations)
  • A map of a web page can be stored into a Grapg DB

https://neo4j.com/developer/graph-database/

26
Q

What is Amazon Neptune?

A
  • A managed graph database.
  • Optimized to run fat queries.
  • CAn store Billions of Relations
  • Good fot maps and fraud detections, for example.

Page 194

27
Q

What is Amazon QLDB?

A
  • Quantum Ledger Database
  • A Immutable DB.
  • Used to register transactions.
  • One a transaction is recorded, it cannot be delete or modified.
  • Good, for example, for logs, history,
  • It is a no decentralization component

Page 195

28
Q

What is Amazon Managed Blockchain?

A
  • Service that allows multiple parties executing transactions without the need for a trusted,
    central authority    .
  • Managed Hyperledger Fabric & Ethereum blockchains
  • It can be Decentralized.
  • it can be joined to a public Blockcahin

Page 196

29
Q

What is Amazon Glue

A
  • A Serveless services that allow you to conbine informations from different services and handled them as a unique source of infromation.
  • it used to prepare and transform data package for analytics.
  • The servie xtract the informatio and prepare/transform it.

Page 197

30
Q

What is Amazon DMS

A
  • Amazon Data Migrate Service
  • Use to migrate DB Schemas and data from one BD Homogeneous or Hetergeneous

Page 198

31
Q

What is AWS Glue Data Catalog?

A

Catalog of Datasets

Page 197

AWS Cloud Practitioner (17 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions