DATA ANALYTICS Questions with Correct Solutions
Question:
1. What is Data Analytics?
Answer:
Data analytics is the collection, transformation, and organization of data in order to draw
conclusions, make predictions, and drive informed decision making.
Question:
2. Do you prefer to ask small questions and let them lead you to the big question? Or you tend
to come up with a big question first?
Answer:
When I work with data, I start with one basic question, but I end up asking so many more
questions as the data shows more information. To me, having a starting point is my critical
step, then as you work, whether in research or troubleshooting, the data you find will give
you answers, not always to the initial question, but to questions you didn't know you had.
Question:
3. Structured data
Answer:
Organized in a certain format, such as rows and columns
Question:
4. Unstructured data
Answer:
Not organized in any easy-to-identify way
Question:
5. Nominal data
Answer:
Qualitative data that is categorized without a set order
Question:
6. Ordinal data
Answer:
Qualitative data with a set order or scale
, Question:
7. Data modeling
Answer:
is the process of creating diagrams that visually represent how data is organized and
structured
Question:
8. Three types of data modeling
Answer:
Conceptual, Logical, Physical
Question:
9. Conceptual data modeling
Answer:
gives a high-level view of the data structure, such as how data interacts across an
organization. For example, a conceptual data model may be used to define the business
requirements for a new database. A conceptual data model doesn't contain technical details
Question:
10. Logical data modeling
Answer:
Focuses on the technical details of a database such as relationships, attributes, and entities.
For example, a logical data model defines how individual records are uniquely identified in a
database. But it doesn't spell out actual names of database tables. That's the job of a physical
data model.
Question:
11. Physical data modeling
Answer:
depicts how a database operates. A physical data model defines all entities and attributes
used; for example, it includes table names, column names, and data types for the database.
Question:
12. Entity Relationship Diagram (ERD)
Answer:
are a visual way to understand the relationship between entities in the data model
Question:
13. Data Dictionary
Question:
1. What is Data Analytics?
Answer:
Data analytics is the collection, transformation, and organization of data in order to draw
conclusions, make predictions, and drive informed decision making.
Question:
2. Do you prefer to ask small questions and let them lead you to the big question? Or you tend
to come up with a big question first?
Answer:
When I work with data, I start with one basic question, but I end up asking so many more
questions as the data shows more information. To me, having a starting point is my critical
step, then as you work, whether in research or troubleshooting, the data you find will give
you answers, not always to the initial question, but to questions you didn't know you had.
Question:
3. Structured data
Answer:
Organized in a certain format, such as rows and columns
Question:
4. Unstructured data
Answer:
Not organized in any easy-to-identify way
Question:
5. Nominal data
Answer:
Qualitative data that is categorized without a set order
Question:
6. Ordinal data
Answer:
Qualitative data with a set order or scale
, Question:
7. Data modeling
Answer:
is the process of creating diagrams that visually represent how data is organized and
structured
Question:
8. Three types of data modeling
Answer:
Conceptual, Logical, Physical
Question:
9. Conceptual data modeling
Answer:
gives a high-level view of the data structure, such as how data interacts across an
organization. For example, a conceptual data model may be used to define the business
requirements for a new database. A conceptual data model doesn't contain technical details
Question:
10. Logical data modeling
Answer:
Focuses on the technical details of a database such as relationships, attributes, and entities.
For example, a logical data model defines how individual records are uniquely identified in a
database. But it doesn't spell out actual names of database tables. That's the job of a physical
data model.
Question:
11. Physical data modeling
Answer:
depicts how a database operates. A physical data model defines all entities and attributes
used; for example, it includes table names, column names, and data types for the database.
Question:
12. Entity Relationship Diagram (ERD)
Answer:
are a visual way to understand the relationship between entities in the data model
Question:
13. Data Dictionary
