DBA / Database

Describe the logical structure of DWH.

Tell us specifically what you do in your current job as a system analyst.

The report data does not match the source system. How will you act?

In DWH, order information is modeled as follows. fct_order - id - create_dt - cost - driver_id dim_driver - driver_id - name - phone How can the data model be improved to store information about multiple driver phones with their types (main, additional, emergency)?

What is a fact table and a dimension table? How to determine what is a fact and what is a dimension?

In which table to store the start and end dates of the number's validity?

Are you interested in working with data and design, or do you want to develop in another direction?

What key should be used for the driver phones table if the same number can belong to different drivers and have different types?

What are the ways to keep track of data change history in a database? For example, how to record a user's surname change?

How to store the change of phone number: error correction and actual change of number?

Have you heard of the "snowflake" schema?

What is a primary key?

Where to store the phone number itself: in the "driver-phone" relation table or in a separate phones table? What are the pros and cons of each option?

What questions would you ask the customer if you need to build a new report?