Question 1mediummultiple choice
Read the full Plan and implement data platform resources explanation →DP-300 Plan and implement data platform resources • Complete Question Bank
Complete DP-300 Plan and implement data platform resources question bank — all 0 questions with answers and detailed explanations.
Refer to the exhibit.
Exhibit:
```
{
"properties": {
"collation": "SQL_Latin1_General_CP1_CI_AS",
"maxSizeBytes": 214748364800,
"sku": {
"name": "GP_Gen5_4",
"tier": "GeneralPurpose",
"capacity": 4
},
"storageAccountType": "GRS",
"zoneRedundant": false
},
"location": "eastus"
}
```Refer to the exhibit. Exhibit: ``` Event ID: 4140 Severity: 16 Message: Could not allocate space for object 'sys.sysrscols' in database 'mydb' because the 'PRIMARY' filegroup is full. ```
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag a concept onto its matching description — or click a concept then click the description.
Suitable for small databases with low performance requirements
Balanced performance for most production workloads
High performance and low latency for mission-critical workloads
Highly scalable storage and compute for large databases
Auto-scaling compute based on workload demand
Drag a concept onto its matching description — or click a concept then click the description.
Provides analysis of query performance and resource consumption
Automatically adjusts indexes and query plans
Proactive diagnostics and performance recommendations
Provides recommendations for index and query optimization
Refer to the exhibit.
```json
{
"type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies",
"apiVersion": "2021-11-01",
"properties": {
"weeklyRetention": "P4W",
"monthlyRetention": "P12M",
"yearlyRetention": "P5Y",
"weekOfYear": 16
}
}
```Refer to the exhibit. ``` RESOURCE GROUP: rg-sql-prod LOCATION: eastus SERVER NAME: sqlprod-server DATABASE NAME: SalesDB SERVICE TIER: BusinessCritical COMPUTE: Gen5, 8 vCores STORAGE: 500 GB BACKUP STORAGE REDUNDANCY: Geo ZONE REDUNDANCY: Enabled ```
Refer to the exhibit. ``` $serverName = "sqlprod-server" $databaseName = "OrdersDB" $cmd = @" SELECT name, state_desc FROM sys.database_service_objectives WHERE database_id = DB_ID() "@ Invoke-SqlCmd -ServerInstance $serverName -Database $databaseName -Query $cmd ```
Refer to the exhibit.
```json
{
"properties": {
"virtualNetworkRules": [
{
"id": "/subscriptions/.../virtualNetworks/vnet1/subnets/subnet1",
"ignoreMissingVnetServiceEndpoint": false
}
],
"ipRules": [
{
"ipAddress": "0.0.0.0",
"action": "Allow"
}
],
"minimalTlsVersion": "1.2",
"publicNetworkAccess": "Disabled"
}
}
```Refer to the exhibit.
```powershell
$params = @{
ResourceGroupName = 'rg-sql'
ServerName = 'sqlserver1'
DatabaseName = 'db1'
Edition = 'GeneralPurpose'
ComputeGeneration = 'Gen5'
VCores = 4
MaxVCores = 8
MinVCores = 0.5
AutoPauseDelayInMinutes = 60
}
New-AzSqlDatabase @params
```Refer to the exhibit.
```json
{
"properties": {
"storageAccountUri": "https://mystorageaccount.blob.core.windows.net/backups",
"retentionDays": 30,
"storageAccountAccessKey": "..."
}
}
```Refer to the exhibit.
```sql
CREATE DATABASE SCOPED CREDENTIAL [https://mystorageaccount.blob.core.windows.net/data]
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'sv=2022-11-02&ss=b&srt=sco&sp=rw&se=2025-01-01T00:00:00Z&st=2024-01-01T00:00:00Z&spr=https&sig=...';
CREATE EXTERNAL DATA SOURCE [MyDataSource]
WITH (
LOCATION = 'https://mystorageaccount.blob.core.windows.net/data',
CREDENTIAL = [https://mystorageaccount.blob.core.windows.net/data]
);
CREATE EXTERNAL TABLE [dbo].[ExternalTable]
(
[ProductID] INT,
[ProductName] NVARCHAR(100)
)
WITH (
LOCATION = 'products/',
DATA_SOURCE = [MyDataSource],
FILE_FORMAT = [ParquetFormat]
);
```Refer to the exhibit.
```json
{
"properties": {
"createMode": "Default",
"sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
"requestedServiceObjectiveName": "GP_Gen5_4",
"elasticPoolId": null,
"location": "eastus"
}
}
```Refer to the exhibit.
```json
{
"properties": {
"createMode": "Recovery",
"sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
"requestedServiceObjectiveName": "GP_Gen5_2",
"elasticPoolId": null,
"location": "eastus"
}
}
```Refer to the exhibit.
```json
{
"properties": {
"createMode": "PointInTimeRestore",
"sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
"requestedServiceObjectiveName": "GP_Gen5_2",
"restorePointInTime": "2025-03-15T10:00:00Z",
"location": "eastus"
}
}
```{
"properties": {
"security": {
"azureAdAdminAuthentication": {
"login": "admin@contoso.com",
"sid": "00000000-0000-0000-0000-000000000000",
"tenantId": "tenant-id",
"type": "User"
}
},
"networkAccessControl": {
"publicNetworkAccess": "Disabled"
},
"firewallRules": []
}
}You are a database administrator for a healthcare company that uses Azure SQL Database for its patient management system. The database is currently 500 GB and uses the General Purpose tier in the West US region. The application experiences high read traffic during business hours, and you need to improve read performance without increasing costs significantly. You also need to ensure that read queries are isolated from write workloads. The application supports read-only routing using connection strings. You have the following options:
A. Create a secondary replica in the same region using active geo-replication and configure the application to use the secondary for read-only queries. B. Upgrade the database to the Business Critical tier and use the built-in readable secondary. C. Implement read scale-out by adding a readable secondary replica in the same region using the built-in read scale-out feature of the General Purpose tier. D. Create an elastic pool with multiple databases and distribute read queries across them.
Which option should you choose?