7.1.2 Data Base Portfolio Flashcards

1
Q

Differentiate On Premises Database, ECSs Database and Cloud Databases

A
  • On premises database needs server procurement, hardware and operating system deployment. They need Equipment hosting fees, High DBA Cost.
  • ECSs Database needs to purchase and install database software. They need rental fees and there’s a high DBA costs.
  • Cloud databases doesn’t need to purchase or install any software or hardware. They only need to pay databases.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is GaussDB?

A

GaussDB(DWS) is a distributed database for data analysis and hybrid transaction/analytical processing. It supports both x86
and Kunpeng architectures and row and column storage, with the capabilities of PB-level data analysis, multi-mode analysis,
and real-time processing. GaussDB(DWS) spans across the core systems of industries such as finance, government, and
telecom

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

What is PostgreSQL?

A

an object-relational database management system (ORDBMS) derived from the POSTGRES package based on the 4.2 version written at
the University of California, Berkeley. Many leading POSTGRES concepts were not around until fairly late in the development of business databases.

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

What is NoSQL?

A

NoSQL refers to non-relational databases. Traditional relational databases are unable to keep up with the ultra-large-scale processing and massive concurrent SNS website requests involved with Internet Web 2.0 websites. NoSQL databases are designed to address the challenges of handling the multiple data types involved in large-scale data collections, especially where big data applications are concerned. NoSQL databases come in a variety of types based on different data models. The main types are key-value pair, wide column, document, and graph.

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

What is Distributed Database Middleware (DDM) ?

A

Distributed Database Middleware (DDM) works with the RDS service to remove a single node’s dependency on hardware, facilitate capacity expansion to address data growth challenges, and ensure fast response to query requests. DDM eliminates the bottlenecks in capacity and performance and ensures that concurrent access is possible for a massive amount of data.

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

What is Data Replication Service (DRS) ?

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

What is Data Replication Service (DRS) ?

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

What is Data Replication Service (DRS) ?

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

What is Data Replication Service (DRS) ?

A

Data Replication Service (DRS) is a stable, secure, and efficient cloud service for online database migration and real-time database synchronization. DRS simplifies data transmission between databases and reduces data transfer costs.

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

What is Data Admin Service (DAS)?

A

Data Admin Service (DAS) enables you to manage DB instances on a web- based console, simplifying database management and improving efficiency and security.

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