Testlet 2
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview
You develop data engineering solutions for Graphics Design Institute, a global media company with offices in New York City, Manchester, Singapore, and Melbourne.
The New York office hosts SQL Server databases that stores massive amounts of customer data. The company also stores millions of images on a physical server located in the New York office. More than 2 TB of image data is added each day. The images are transferred from customer devices to the server in New York.
Many images have been placed on this server in an unorganized manner, making it difficult for editors to search images. Images should automatically have object and color tags generated. The tags must be stored in a document database, and be queried by SQL
You are hired to design a solution that can store, transform, and visualize customer data.
Requirements
Business
The company identifies the following business requirements:
– You must transfer all images and customer data to cloud storage and remove on-premises servers.
– You must develop an analytical processing solution for transforming customer data.
– You must develop an image object and color tagging solution.
– Capital expenditures must be minimized.
– Cloud resource costs must be minimized.
Technical
The solution has the following technical requirements:
– Tagging data must be uploaded to the cloud from the New York office location.
– Tagging data must be replicated to regions that are geographically close to company office locations.
– Image data must be stored in a single data store at minimum cost.
– Customer data must be analyzed using managed Spark clusters.
– Power BI must be used to visualize transformed customer data.
– All data must be backed up in case disaster recovery is required.
Security and optimization
All cloud data must be encrypted at rest and in transit.
The solution must support:
– parallel processing of customer data
– hyper-scale storage of images
– global region data replication of processed image data
You need to recommend a solution for storing the image tagging data.
What should you recommend?
A . Azure File Storage
B . Azure Cosmos DB
C . Azure Blob Storage
D . Azure SQL Database
E . Azure Synapse Analytics
Answer: C
Explanation:
Image data must be stored in a single data store at minimum cost. Note: Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.
Blob storage is designed for:
– Serving images or documents directly to a browser.
– Storing files for distributed access.
– Streaming video and audio.
– Writing to log files.
– Storing data for backup and restore, disaster recovery, and archiving.
– Storing data for analysis by an on-premises or Azure-hosted service.
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blobs-introduction