Free Microsoft Azure Data Fundamentals Questions and Answers

Question 1

Which kind of items in a relational database should you configure a datatype for?

Accepted Answer

columns

Answer

In a relational database, datatypes are configured for columns (also known as attributes). Each column stores a specific type of data, such as integers, text, or dates, for all rows in the table. This ensures data integrity and consistency within that particular column.

Question 2

To aggregate the content of two tables based on a shared column, which SQL operation is used?

Accepted Answer

JOIN

Answer

The `JOIN` operation in SQL is used to combine rows from two or more tables based on a related column between them. This allows you to retrieve data that is spread across multiple tables, creating a single, unified result set. Other operations like `UNION` combine rows from result sets, not based on shared columns.

Question 3

What SQL clause should be used to copy every row from one table to another?

Accepted Answer

SELECT - INTO

Answer

The `SELECT ... INTO` statement in SQL is specifically designed to copy all or a subset of rows from one table into a *new* table. It creates the new table and inserts the selected data in a single operation. `INSERT - VALUES` adds rows to an existing table, while `UPDATE` modifies existing rows.

Question 4

Data integrity is ensured and duplicate data is decreased in databases using the ______________ procedure.

Accepted Answer

Normalization

Answer

Normalization is a systematic process of organizing the columns and tables of a relational database to minimize data redundancy and improve data integrity. It involves decomposing tables into smaller, related tables and defining relationships between them. This structured approach helps prevent anomalies and ensures data consistency.

Question 5

Which three claims about a table's characteristics in a relational database are true?
Select all applicable answers.

Accepted Answer

A table's rows and columns all have the same number of columns.

Answer

In a relational table, all rows must have the same number of columns, ensuring a consistent structure. Each column also requires a defined datatype to specify the kind of data it will hold, enforcing data integrity. A primary key, which uniquely identifies each row, can indeed be composed of one or more columns (a composite primary key).

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Free Microsoft Azure Data Fundamentals Questions and Answers