Microsoft DP-900 Practice Test - Questions Answers, Page 5

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/

Box 1: Yes

Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.

PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources

Box 2: No

You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Box 3: No

There really is no way to pause / stop billing for your Azure SQL Database.

Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing.

Then when you need it you can create a new database and import your previously exported DB."

Reference:

https://azure.microsoft.com/en-us/overview/what-is-paas

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/

Reference:

https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms

https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Reference:

https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/

https://azure.microsoft.com/en-us/services/sql-database/#product-overview

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server

Reference:

https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql