DP-300 Practice Test

ColumnC

Explanation:
Example:
Free space for the file in the below query result set will be returned by the FreeSpaceMB
column.
SELECT DB_NAME() AS DbName,
name AS FileName,
type_desc,
size/128.0 AS CurrentSizeMB,
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB
FROM sys.database_files
WHERE type IN (0,1);
Reference:
https://www.sqlshack.com/how-to-determine-free-space-and-file-size-for-sql-serverdatabases/
You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should

an actual execution plan

Explanation:
To include an execution plan for a query during execution
1. On the SQL Server Management Studio toolbar, click Database Engine Query. You can
also open an existing query and display the estimated execution plan by clicking the Open
File toolbar button and locating the existing query.
2. Enter the query for which you would like to display the actual execution plan.
3. On the Query menu, click Include Actual Execution Plan or click the Include Actual
Execution Plan toolbar button.

Note: Actual execution plans are generated after the Transact-SQL queries or batches
execute. Because of this, an actual execution plan contains runtime information, such as
actual resource usage metrics and runtime warnings (if any). The execution plan that is
generated displays the actual query execution plan that the SQL Server Database Engine
used to execute the queries.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/display-an-actualexecution-
plan

two Azure SQL Databases in an elastic pool

Explanation:
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and
scaling multiple databases that have varying and unpredictable usage demands. The
databases in an elastic pool are on a single server and share a set number of resources at
a set price.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

a private link

Explanation:
Azure Private Link enables you to access Azure PaaS Services (for example, Azure
Storage and SQL Database) and Azure hosted customer-owned/partner services over a
private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone
network. Exposing your service to the public internet is no longer necessary.
Reference:
https://docs.microsoft.com/en-us/azure/private-link/private-link-overview