2.3. Describe Azure storage services

To complete the sentence, select the appropriate option in the answer area.

Azure Cosmos DB is an example of a xxxxxx offering

Match the Azure service to the appropriate description. (To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.)

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

One of the benefits of Azure SQL Data Warehouse is that high availability is built into the platform.

Review the text. If it makes the statement correct, select “No change is needed”. If the statement is incorrect, select the answer choice that makes the statement correct.

You need to purchase a third-party virtual security appliance that you will deploy to an Azure subscription.
What should you use?

What is the benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

You plan to store 20 TB of data in Azure. The data will be accessed infrequently and visualized by using Microsoft Power BI. You need to recommend a storage solution for the data.

Which two solutions should you recommend? (Select two.)

Your company is planning a deployment using Azure Database for PostgreSQL. The deployment should meet the following requirements:

– Up to 10 TB of storage

– Azure Premium Storage

– Point-in-time-restore for up to 35 days.

You need to select the appropriate deployment and pricing tier to meet these requirements and minimize costs.
What should you select?

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.

What should you use?

You plan to create an Azure virtual machine. You need to identify which storage service must be used to store the unmanaged data disks of the virtual machine.

What should you identify? (To answer, select the appropriate service in the answer area.)

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? (Select two.)

You have a transactional application that stores data in an Azure SQL-managed instance.
When should you implement a read-only database replica?

You plan to map a network drive from several computers that run Windows 10 to Azure Storage. You need to create a storage solution in Azure for the planned mapped drive.

What should you create?

Which statement is an example of Data Manipulation Language (DML)?

You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? (Select three.)

You plan to implement an Azure database solution. You need to implement a database solution that meets the following requirements:

– Can add data concurrently from multiple regions

– Can store JSON documents

Which database service should you deploy? (To answer, select the appropriate service in the answer area.)

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?

You have an Azure subscription that contains an Azure Storage account. You plan to create an Azure container instance named container1 that will use a Docker image named Image1. Image1 contains a Microsoft SQL Server instance that requires persistent storage. You need to configure a storage service for Container 1.
What should you use?

To complete the sentence, select the appropriate option in the answer area.

Data that is stored in the archive access tier of an Azure storage account ..XXX

What are the two characteristics of real-time data processing? (Select two.)

You have an Azure subscription named Subscription1. You have 5 TB of data that you need to transfer to Subscription. You plan to use an Azure Import/Export job.
What can you use as the destination of the imported data?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Data that is copied to an Azure storage account is maintained automatically in at least three copies.

You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?

For each of the following statements, select Yes if the statement is true. Otherwise, select N0.

all data that is copied to an Azure storage account is backed up automatically to another Azure data center.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

An azure storage account can contain up to 2 TB of data and up to one million files.

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

You have an Azure virtual machine that is accessed only between 9:00 and 17:00 each day.

What should you do to minimize costs but preserve the associated hard disks and data?

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

You are required to deploy an Artificial Intelligence (AI) solution in Azure. You want to make sure that you are able to build, test, and deploy predictive analytics for the solution.
Solution: You should make use of Azure Cosmos DB.
Does the solution meet the goal?

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook.
What should you use?

Your company has data centers in Los Angeles and New York. The company has a Microsoft Azure subscription. You are configuring the two datacenters as geo-clustered sites for site resiliency. You need to recommend an Azure storage redundancy option. You have the following data storage requirements:
– Data must be stored on multiple nodes.
– Data must be stored on nodes in separate geographic locations.
– Data can be read from the secondary location as well as from the primary location
Which of the following Azure stored redundancy options should you recommend?

You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

Which of the following is not a requirement for creating an online secondary for SQL Database?

You have an Azure SQL database that you access directly from the Internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?

You want to extract insights by querying and transforming data for which you would require an Azure big data solution.
Identify which of the following you think is the most appropriate tool to use.

You are deploying software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?

Your company plans to migrate all its data and resources to Azure. The company’s migration plan states that only Platform as a Service (PaaS) solutions must be used in Azure. You need to deploy an Azure environment that supports the planned migration.

Solution: You create an Azure App Service and Azure SQL databases.

Does this meet the goal?

A company maintains an Azure storage account. The storage account uses blobs and tables. Customers access the storage account by using shared access signatures (SASs). You need to monitor the usage of the storage services. You need to do the following:
Which three data analysis tasks should you perform? (Select three.)

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? (Select two.)