Question 1mediummultiple choice
Read the full Describe considerations for working with non-relational data on explanation →DP-900 Describe considerations for working with non-relational data on Azure • Complete Question Bank
Complete DP-900 Describe considerations for working with non-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.
Locally redundant storage within a single datacenter
Zone-redundant storage across availability zones
Geo-redundant storage with cross-region replication
Read-access geo-redundant storage
Geo-zone-redundant storage
Drag a concept onto its matching description — or click a concept then click the description.
Low-cost for small workloads
Balanced performance and cost
High performance and low latency
Highly scalable for large databases
Auto-scaling compute based on demand
{
"version": "2019-01-01",
"name": "assignSasPolicy",
"type": "Microsoft.Authorization/policyAssignments",
"properties": {
"policyDefinitionId": "/providers/Microsoft.Authorization/policyDefinitions/abcd-1234",
"parameters": {
"effect": "deny"
},
"scope": "/subscriptions/12345/resourceGroups/rg1/providers/Microsoft.Storage/storageAccounts/storage1"
}
}{
"kind": "StorageV2",
"properties": {
"isHnsEnabled": true,
"encryption": {
"keySource": "Microsoft.Storage"
},
"networkAcls": {
"defaultAction": "Deny",
"virtualNetworkRules": [],
"ipRules": []
},
"supportsHttpsTrafficOnly": true
}
}{
"databaseAccountOfferType": "Standard",
"capabilities": [
{
"name": "EnableCassandra"
}
],
"locations": [
{
"locationName": "West US",
"failoverPriority": 0
},
{
"locationName": "East US",
"failoverPriority": 1
}
],
"consistencyPolicy": {
"defaultConsistencyLevel": "Session"
}
}{
"PartitionKey": "user123",
"RowKey": "settings",
"theme": "dark",
"language": "en"
}{
"id": "1",
"name": "Product A",
"category": "Electronics",
"price": 199.99,
"tags": ["new", "sale"]
}{
"name": "data.csv",
"content": "id,name,age\n1,Alice,30\n2,Bob,25"
}Refer to the exhibit.
```json
{
"version": "2019-12-12",
"rules": [
{
"name": "rule1",
"enabled": true,
"type": "Lifecycle",
"definition": {
"filters": {
"blobTypes": ["blockBlob"],
"prefixMatch": ["logs/"]
},
"actions": {
"baseBlob": {
"tierToCool": {
"daysAfterModificationGreaterThan": 30
},
"tierToArchive": {
"daysAfterModificationGreaterThan": 90
},
"delete": {
"daysAfterModificationGreaterThan": 365
}
}
}
}
}
]
}
```Refer to the exhibit.
```sql
CREATE TABLE SensorData (
DeviceID INT,
Timestamp DATETIME2,
Temperature FLOAT,
Humidity FLOAT
)
WITH (
DISTRIBUTION = HASH(DeviceID),
CLUSTERED COLUMNSTORE INDEX
);
```Refer to the exhibit.
```json
{
"containers": [
{
"name": "container1",
"properties": {
"publicAccess": "Blob"
}
}
]
}
```{
"dataLakeStoreGen2": {
"hierarchicalNamespace": {
"enabled": true
}
},
"encryption": {
"keySource": "Microsoft.Storage"
}
}{
"storageAccount": {
"name": "mystorageaccount",
"kind": "StorageV2",
"properties": {
"accessTier": "Hot"
}
},
"container": {
"name": "data",
"properties": {
"accessTier": "Cool"
}
}
}{
"apiVersion": "2023-01-01",
"type": "Microsoft.DocumentDB/databaseAccounts",
"name": "cosmosdb-account",
"properties": {
"databaseAccountOfferType": "Standard",
"locations": [
{
"locationName": "West US",
"failoverPriority": 0
},
{
"locationName": "East US",
"failoverPriority": 1
}
],
"consistencyPolicy": {
"defaultConsistencyLevel": "Session"
}
}
}{ "version": "1.0", "statement": "SELECT * FROM c WHERE c.age > 25" }