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

rows

Answer

tables

Answer

fields

Answer

relationships

Question 2

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

Accepted Answer

JOIN

Answer

UNION

Answer

INTERSECT

Answer

HAVING

Question 3

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

Accepted Answer

SELECT - INTO

Answer

INSERT – VALUES

Answer

SELECT – HAVING

Answer

UPDATE

Question 4

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

Accepted Answer

Normalization

Answer

Projecting

Answer

Indexing

Answer

Refactoring

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

There can only be one foreign key per table.

Answer

Values must be present in every column.

Question 6

You must suggest a remedy that satisfies the following criteria:
- Comprises business logic that allows for database product renaming
- Increases table entries
What should the recommendation contain?

Accepted Answer

a stored procedure

Answer

an inline function

Answer

a view

Answer

a table-valued function

Question 7

What can you use in a relational database to make a virtual table out of the results of a SELECT statement?

Accepted Answer

a view

Answer

a relationship

Answer

a stored procedure

Answer

an index

Question 8

You have a folder with text files, pictures, and audio files in it.
What kind of data do you have?

Accepted Answer

unstructured

Answer

semi-structured

Answer

structured

Question 9

What kind of database would work best for an organizational chart?

Accepted Answer

graph

Answer

columnar

Answer

Azure Table storage

Answer

Azure SQL Database

Question 10

Which database type should you employ to store sequential data as quickly as possible?

Accepted Answer

time series

Answer

Azure Table storage

Answer

graph

Answer

Azure SQL Database