A company plans to use Azure Storage for file storage purposes. Compliance rules require:
A single storage account to store all operations including reads, writes and deletes
Retention of an on-premises copy of historical operations
You need to configure the storage account.
Which two actions should you perform?
Configure the storage account to log read, write and delete operations for service type Blob
Use the AzCopy tool to download log data from $logs/blob
Configure the storage account to log read, write and delete operations for service-type table
Use the storage client to download log data from $logs/table
Configure the storage account to log read, write and delete operations for service type queue
Answers are; "Configure the storage account to log read, write and delete operations for service type Blob" and
"Use the AzCopy tool to download log data from $logs/blob"
Storage Logging logs request data in a set of blobs in a blob container named $logs in your storage account. This container does not show up if you list all the blob containers in your account but you can see its contents if you access it directly.
To view and analyze your log data, you should download the blobs that contain the log data you are interested in to a local machine. Many storage-browsing tools enable you to download blobs from your storage account; you can also use the Azure Storage team provided command-line Azure Copy Tool (AzCopy) to download your log data.
A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year.
Which two factors affect your costs when sizing the Azure SQL Database elastic pools?
maximum data size
number of databases
eDTUs consumption
number of read operations
number of transactions
Answers are "maximum data size" and "eDTUs consumption"
maximum data size: With the vCore purchase model, in the General Purpose tier, you are charged for Premium blob storage that you provision for your database or elastic pool. Storage can be configured between 5 GB and 4 TB with 1 GB increments. Storage is priced at GB/month.
eDTUs consumption: In the DTU purchase model, elastic pools are available in basic, standard and premium service tiers. Each tier is distinguished primarily by its overall performance, which is measured in elastic Database Transaction Units (eDTUs).
Which data store is the least expensive choice when you want to store data but don't need to query it?
Azure Stream Analytics
Azure Databricks
Azure Storage
Answer is Azure Storage
Azure Storage offers a massively scalable object store for data objects and file system services for the cloud. If you create a Blob storage account, you can't directly query the data.
Azure Databricks is a serverless platform that's optimized for Azure. It provides one-click setup, streamlined workflows, and an interactive workspace for Spark-based applications.
In real time, Azure Stream Analytics ingests streaming data from applications or Internet of Things (IoT) devices and gateways into an event hub or an IoT hub. Then the event hub or IoT hub streams the data into Azure Stream Analytics for real-time analysis.
Question 274
A JSON file is an example of which type of data?
Structured
Semi-structured
Unstructured
Answer is Semi-structured
Semi-structured data contains tags that make the organization and hierarchy of the data apparent.
Question 275
A video is an example of which type of data?
Structured
Semi-structured
Unstructured
Answer is Unstructured
Unstructured data is often delivered in files. A video may have an overall structure but the data that comprises the video itself is unstructured.
Question 276
Which type of transactional database system would work best for product data?
OLAP
OLTP
Answer is OLTP
OLTP systems support a large set of users, have quick response times, handle large volumes of data, are highly available, and are great for small or relatively simple transactions.
Question 277
Suppose the operations to update inventory and process payments are in the same transaction. A user is attempting to apply store credit for the full amount of an order, and submitted the exact same order (for the full amount) using their phone and laptop at the same time - so two identical orders are received. The database behind the scenes is an ACID-compliant database, what would happen?
Both orders would be processed and use the in-store credit.
One order would be processed and use the in-store credit, and the other order would update the remaining inventory for the items in the basket, but would not complete the order.
One order would be processed and use the in-store credit, and the other order would not be processed.
Answer is "One order would be processed and use the in-store credit, and the other order would not be processed."
Once the second order determined that the in-store credit has already been used, it would roll back the transaction.
Question 278
Suppose you have two video files stored as blobs. One of the videos is business-critical and requires a replication policy that creates multiple copies across geographically diverse datacenters. The other video is non-critical, and a local replication policy is sufficient.
Which of the following options would satisfy both data diversity and cost sensitivity consideration?
Create a single storage account that makes use of Local-redundant storage (LRS) and host both videos from here.
Create a single storage account that makes use of Geo-redundant storage (GRS) and host both videos from here.
Create a two storage accounts. The first account makes use of Geo-redundant storage (GRS) and hosts the business-critical video content. The second account makes use of Local-redundant storage (LRS) and hosts the non-critical video content.
Answer is "Create a two storage accounts. The first account makes use of Geo-redundant storage (GRS) and hosts the business-critical video content. The second account makes use of Local-redundant storage (LRS) and hosts the non-critical video content."
In general, increased diversity means an increased number of storage accounts. A storage account by itself has no financial cost. However, the settings you choose for the account do influence the cost of services in the account. Use multiple storage accounts to reduce costs.
The usage of single storage account to host both videos in a single LRS enabled storage account takes cost savings into consideration, but doesn't consider the data diversity storage requirements for business-critical content.
The usage of single storage account to host both videos in a single RRS enabled storage account takes data diversity into consideration, but doesn't consider the cost savings requirements for non-critical content.
Question 279
The name of a storage account must be:
Unique within the containing resource group.
Unique within your Azure subscription.
Globally unique.
Answer is Globally unique.
The storage account name is used as part of the URI for API access, so it must be globally unique.
Question 280
In a typical project, when would you create your storage account(s)?
At the beginning, during project setup.
After deployment, when the project is running.
At the end, during resource cleanup.
Answer is At the beginning, during project setup.
Storage accounts are stable for the lifetime of a project. It's common to create them at the start of a project.