HOTSPOT

For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Reveal Solution Hide Solution

HOTSPOT

You have the following SQL query.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

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

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.

What should you use?

Reveal Solution Hide Solution

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?

Reveal Solution Hide Solution

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: No

Microsoft handles all patching and updating of the SQL and operating system code. You don’t have to manage the underlying infrastructure.

Box 2: Yes

SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.

Box 3: No

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

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

Reveal Solution Hide Solution

When you create an Azure SQL database, which account can always connect to the database?

Reveal Solution Hide Solution