1) In the context of relational data, which of the following statements best describes the process of data normalization? | Select the correct optionSelect the correct option a) The data has been marked as read-only. b) Data is split into a large number of narrow, well-defined tables.  c) Data is stored in a format that more closely matches the original structure. d) Data has been ingested and transformed ready for querying 2) Which activity listed below is the responsibility of the Azure Database Engineer? | Select the correct option a) Allocating system storage and planning storage requirements for the database system. b) Controlling and monitoring user access to the database. c) Ensuring compliance with the database vendor license agreement. d) Developing processes for creating and retrieving information from data sets. 3) Which of the roles listed below are most likely to use SQL to query a database? | Select the correct option a) Data Analyst  b) Data Engineer c) Database Administrator  d) Cloud solution Architect 4) In relational database design, which of the following statements best describes the use of a Foreign Key? | Select all that apply. a) They indicate the column (or combination of columns) that uniquely identify each row. b) They reference, or link to, the primary key of another table, and are used to maintain the relationships between tables. c) They are used to identify whether a user has write-access to a specific table. d) They indicate the column where data has been ingested from a different table. 5) Which of the following statements are true of a relational database? a) A table can contain any number of rows.  b) A Primary Key is used to indicate the column (or combination of columns) that uniquely identify each row. c) Rows in the same table can have different sets of fields. d) The data is tabular. 

Azure Data Fundamentals | Explore Core Data Concepts

Басып шығару
Ендіру

Көшбасшылар тақтасы

Визуалды стиль

Опциялар

Үлгіні ауыстыру

Өңдеуді жалғастыру: ?