WEEK 4 DBMS

Database Administrator

• Focus: Infrastructure, security, performance tuning, backups, and keeping the lights on.

• Day in the Life: Setting up user access controls (Granular Security), monitoring server CPU usage, and testing Disaster Recovery plans. If the server crashes at 2 AM, the DBA gets the phone call.

• Mindset: "I protect the data and ensure it is always available."

The Mechanic

What is the role of the Database Administrator?

Database Developer / Data Engineer

• Focus: Designing schemas, writing complex SQL, building ETL (Extract, Transform, Load) pipelines, and integrating databases with applications.

• Day in the Life: Writing the SQL queries that the mobile app uses to load a user's profile in under 50 milliseconds. Building a pipeline that pulls data from a web API, cleans it, and loads it into a Data Warehouse.

• Mindset: "I build the engines and pipes that move and store the data efficiently."

The Builder

What is the role of Database Developer / Data Engineer

Data Analyst / BI Developer

• Focus: Querying data to find trends, building dashboards (PowerBI, Tableau), and supporting business decisions.

• Day in the Life: The Marketing Director asks, "Why did sales drop in Region 4 last Tuesday?" The Analyst writes complex JOIN and GROUP BY queries to find the answer and builds a visual dashboard to present to the board.

• Mindset: "I turn raw data into business wisdom (DIKW!)."

The Detective

What is the role of Data Analyst / BI Developer

Data Architect

• Focus: High-level enterprise design, aligning database strategy with business goals, creating conceptual and logical data models (ERDs).

• Day in the Life: Meeting with business stakeholders to figure out what data the company needs to track over the next 5 years, and drawing the blueprints (Data Models) that the Database Developers will eventually build.

• Mindset: "I design the city; the Developers build the buildings; the DBA maintains the roads."

The Architect

What is the role of Data Architec?

C

Which role is known as "The Mechanic"?

A. Data Architect
B. Data Analyst
C. Database Administrator
D. Data Engineer

B

What is the main focus of a Database Administrator (DBA)?

A. Building dashboards
B. Infrastructure, security, performance, and backups
C. Designing business presentations
D. Creating marketing strategies

C

If a database server crashes at 2 AM, who is most likely to receive the phone call?

A. Data Analyst
B. Data Architect
C. Database Administrator
D. Front-end Developer

D

A DBA's mindset is:

A. "I turn raw data into business wisdom."
B. "I design the city."
C. "I build the engines and pipes."
D. "I protect the data and ensure it is always available."

B

Which role is known as "The Builder"?

A. Database Administrator
B. Database Developer / Data Engineer
C. Data Analyst
D. Data Architect

A

Which is a main responsibility of a Database Developer / Data Engineer?

A. Writing complex SQL
B. Managing employee salaries
C. Presenting marketing reports
D. Creating company policies

A

What does ETL stand for?

A. Extract, Transform, Load
B. Enter, Transfer, Link
C. Extract, Test, Launch
D. Edit, Transform, List

B

Which task BEST describes the Database Developer / Data Engineer?

A. Protecting the database from unauthorized access
B. Building systems and pipelines that move and store data
C. Creating dashboards for executives
D. Designing the company's five-year business strategy

C

The mindset of the Data Engineer is:

A. "I protect the data."
B. "I turn raw data into business wisdom."
C. "I build the engines and pipes that move and store the data efficiently."
D. "I design the city."

A

Which role is known as "The Detective"?

A. Data Analyst / BI Developer
B. DBA
C. Data Engineer
D. Data Architect

B

What is the main focus of a Data Analyst / BI Developer?

A. Server maintenance
B. Querying data, finding trends, and building dashboards
C. Designing database infrastructure
D. Setting up backups

B

Which tools are specifically mentioned for dashboards?

A. MySQL and Oracle
B. PowerBI and Tableau
C. Python and Java
D. AWS and Azure

C

A Marketing Director asks, "Why did sales drop in Region 4 last Tuesday?" Who would most likely investigate the data?

A. DBA
B. Data Engineer
C. Data Analyst / BI Developer
D. Data Architect

B

Which SQL concepts are specifically mentioned as tools used by the Data Analyst?

A. INSERT and DELETE
B. JOIN and GROUP BY
C. CREATE and DROP
D. UPDATE and ALTER

JOIN and GROUP BY

Which SQL concepts are specifically mentioned as tools used by the Data Analyst?

C

What does the Data Analyst turn raw data into?

A. Hardware
B. Database servers
C. Business wisdom
D. Application code

D

The Data Analyst's mindset is:

A. "I protect the data and ensure it is always available."
B. "I design the city."
C. "I build the engines and pipes."
D. "I turn raw data into business wisdom."

C

Which role is known as "The Architect"?

A. Data Analyst
B. Database Administrator
C. Data Architect
D. Data Engineer

A

What is the main focus of a Data Architect?

A. High-level enterprise design and database strategy
B. Monitoring CPU usage
C. Writing dashboard queries
D. Fixing server crashes

A

Which activity is associated with a Data Architect?

A. Creating conceptual and logical data models
B. Testing computer hardware
C. Managing social media
D. Writing front-end CSS

A

What does ERD relate to in the Data Architect's work?

A. Data models
B. Server cooling
C. Backup schedules
D. Dashboard colors

A

A Data Architect meets with business stakeholders to determine what data the company needs to track over the next 5 years. What are they doing?

A. Performing database maintenance
B. Planning high-level data design
C. Creating a sales dashboard
D. Writing ETL code

D

Who creates the blueprints/data models that Database Developers will eventually build?

A. Data Analyst
B. DBA
C. Data Engineer
D. Data Architect

C

Which statement BEST describes the Data Architect?

A. Maintains the database roads
B. Turns data into business wisdom
C. Designs the overall data structure and strategy
D. Builds data pipelines

Hard Skills

The "Non-Negotiables" in your skill stack are also referred to as________________

SQL Mastery

___________ is described as the ability to write queries in your sleep.

Normalization

The process of eliminating data anomalies is called ________.

roadblock

When addressing the CEO's demand to keep data forever, you must explain the Value vs. Cost curve without sounding like an IT ________.

Data Modeling

You must know how to translate business rules into tables.

Soft Skills

“The Accelerators" in your skill stack are also referred to as______________

Consistency

Only Valid data is saved

Durability

Once saved, it survive a crash

Isolation

Concurrent transasction don’t interfere

Atomicity

All or nothing

False (It’s the Opposite)

True or False: having a degree is what actually gets you the job, while certifications just get you the interview.

True

True of False: Getting just one foundational cloud data certification puts you in the top 10% of entry-level applicants.

False (Sa Enterprise/Legacy siya)

The Oracle Certified Professional (OCP) certification is considered the current "gold standard" for high-growth cloud systems.

True

True or False: AWS Certified Database (Specialty) and Google Cloud Professional Data Engineer are examples of cloud certifications.

False

The Oracle Certified Professional (OCP) certification is rarely used anymore and is being completely phased out of banking and government.

The Degree

The Basecamp serve as?

Data Lake

A massive repository of raw, unstructured data (images, logs, raw text). "Dump it all in, we'll figure out how to use it later."

Data Warehouse

Highly structured, cleansed data optimized for analytics and BI dashboards. Ready for business intellegence

Cloud-Native & Serverless

(e.g., Snowflake, Aurora). Zero server management. You no longer pay for hardware; you only pay for the exact queries you run.

AI-Driven Tuning

Modern DBMSs use machine learning to automatically create indexes and self-tune.