Question 1mediummultiple choice
Read the full Identify considerations for relational data on explanation →DP-900 Identify considerations for relational data on Azure • Complete Question Bank
Complete DP-900 Identify considerations for relational data on Azure question bank — all 0 questions with answers and detailed explanations.
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.
Extract, Transform, Load
Extract, Load, Transform
Processing large volumes of data at scheduled intervals
Processing data in real-time as it arrives
Online Transaction Processing
Drag a concept onto its matching description — or click a concept then click the description.
Encrypts data at rest automatically
Encrypts data in use and in transit
Identity-based access control
IP-level network restrictions
Private IP connectivity over Azure backbone
Drag a concept onto its matching description — or click a concept then click the description.
Reads always see the latest write
Reads may lag behind writes by up to K versions or T time
Consistent reads within a client session
Reads never see out-of-order writes
No ordering guarantee, eventually consistent
Refer to the exhibit.
```json
{
"properties": {
"resource": {
"type": "Microsoft.Sql/servers/databases"
},
"policyRule": {
"if": {
"field": "Microsoft.Sql/servers/databases/zoneRedundant",
"equals": false
},
"then": {
"effect": "deny"
}
}
}
}
```Refer to the exhibit.
```bash
# Azure CLI output
{
"name": "myfailovergroup",
"partnerServers": [
{
"id": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server2",
"location": "eastus",
"replicationRole": "Primary"
},
{
"id": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1",
"location": "westus",
"replicationRole": "Secondary"
}
],
"readWriteEndpoint": {
"failoverPolicy": "Automatic",
"failoverWithDataLossGracePeriodMinutes": 60
},
"readOnlyEndpoint": {
"failoverPolicy": "Disabled"
},
"databases": [
"/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/mydb"
]
}
```Refer to the exhibit. ```sql -- KQL query from Azure Monitor AzureDiagnostics | where ResourceProvider == "MICROSOFT.SQL" | where Category == "SQLSecurityAuditEvents" | where action_id_s == "DATABASE_LOGOUT" | summarize Count = count() by user_name_s, bin(TimeGenerated, 1h) | top 10 by Count desc ```
Refer to the exhibit.
```json
{
"properties": {
"databaseName": "SalesDB",
"requestedServiceObjectiveName": "S2",
"edition": "Standard",
"maxSizeBytes": 268435456000
}
}
```Refer to the exhibit.
```sql
CREATE DATABASE SCOPED CREDENTIAL MyCred
WITH IDENTITY = 'Managed Identity'
GO
CREATE EXTERNAL DATA SOURCE MyDataSource
WITH (
LOCATION = 'https://mystorageaccount.blob.core.windows.net/container',
CREDENTIAL = MyCred
)
GO
CREATE EXTERNAL TABLE dbo.SalesExternal
(
SaleID int,
SaleDate datetime2,
Amount decimal(10,2)
)
WITH (
LOCATION = 'sales/',
DATA_SOURCE = MyDataSource,
FILE_FORMAT = MyFileFormat
)
```Refer to the exhibit.
```json
{
"properties": {
"serverName": "myserver",
"administratorLogin": "adminuser",
"administratorLoginPassword": "P@ssw0rd!",
"version": "12.0",
"location": "eastus"
}
}
```Refer to the exhibit.
```json
{
"properties": {
"createMode": "Default",
"location": "eastus",
"sku": {
"name": "GP_Gen5_2",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 2
}
}
}
```Refer to the exhibit. ```kusto // KQL query in Azure Monitor AzureDiagnostics | where ResourceProvider == "MICROSOFT.SQL" | where Category == "QueryStoreRuntimeStatistics" | summarize avg_duration = avg(duration_s) by DatabaseName | order by avg_duration desc ```
Refer to the exhibit.
```json
{
"properties": {
"serviceObjectiveName": "S2",
"maxSizeBytes": 268435456000,
"requestedServiceObjectiveName": "S2"
}
}
```Refer to the exhibit.
```json
{
"properties": {
"firewallRules": [
{
"startIpAddress": "10.0.0.0",
"endIpAddress": "10.0.0.0"
},
{
"startIpAddress": "192.168.1.0",
"endIpAddress": "192.168.1.255"
}
]
}
}
```