Explanation:

Generally speaking, data analytics comes in four types (Figure 1):

Descriptive, to answer the question : What’s happening?

Diagnostic, to answer the question: Why’s happening?

Predictive, to answer the question: What will happen?

Prescriptive, to answer the question: What actions should we take?

Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-

will-happen-with-iot-analytics/

Explanation:

Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server/

Explanation:

Disadvantages of non-relational databases include: Data Consistency ― non-relational databases do not perform ACID transactions.

Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

Incorrect Answers:

Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.

Use Cloud storage (no relational database) for geographically distributed writes.

Reference: https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

Box 1: SELECT

Box 2: GROUP BY

Example:

When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.

SELECT TerritoryID, AVG(Bonus)as ‘Average bonus’, SUM(SalesYTD) as ‘YTD sales’

FROM Sales.SalesPerson

GROUP BY TerritoryID;

Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

Explanation:

Box 1: Yes

Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

Box 2: No

An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the

table or view.

Box 3: Yes

A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described

https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15