<< Prev Question Next Question >>

Question 43/50

You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections.
Each region maintains its own private virtual network.
Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data.
Microsoft Azure SQL Databases must be provisioned.
* Database provisioning must maximize performance and minimize cost
* The daily sales for each region must be stored in an Azure SQL Database instance
* Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance You need to provision Azure SQL database instances.
How should you provision the database instances? To answer, drag the appropriate Azure SQL products to the correct databases. Each Azure SQL product may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (50q)
Question 1: Use the following login credentials as needed: Azure Usernam...
Question 2: You are monitoring the Data Factory pipeline that runs from ...
Question 3: You have an enterprise data warehouse in Azure Synapse Analy...
Question 4: You need to ensure that phone-based poling data can be analy...
Question 5: A company manages several on-premises Microsoft SQL Server d...
Question 6: Use the following login credentials as needed: Azure Usernam...
Question 7: You are developing a solution using a Lambda architecture on...
Question 8: Note: This question is part of a series of questions that pr...
Question 9: (Exhibit) Use the following login credentials as needed: Azu...
Question 10: You are responsible for providing access to an Azure Data La...
Question 11: A company is deploying a service-based data environment. You...
Question 12: Which two metrics should you use to identify the appropriate...
Question 13: You need to implement complex stateful business logic within...
Question 14: A company uses Microsoft Azure SQL Database to store sensiti...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: Use the following login credentials as needed: Azure Usernam...
Question 17: You plan to monitor an Azure data factory by using the Monit...
Question 18: Note: This question is part of a series of questions that pr...
Question 19: Note: This question is part of a series of questions that pr...
Question 20: You manage security for a database that supports a line of b...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: You use Azure Stream Analytics to receive Twitter data from ...
1 commentQuestion 23: (Exhibit) Use the following login credentials as needed: Azu...
Question 24: You need to ensure that phone-based polling data can be anal...
Question 25: You are a data architect. The data engineering team needs to...
Question 26: You need to mask tier 1 data. Which functions should you use...
Question 27: Note: This question is part of a series of questions that pr...
Question 28: A company plans to analyze a continuous flow of data from a ...
Question 29: A company uses Azure SQL Database to store sales transaction...
Question 30: You implement an event processing solution using Microsoft A...
Question 31: You implement an Azure SQL Data Warehouse instance. You plan...
Question 32: You develop data engineering solutions for a company. The co...
1 commentQuestion 33: You have the following Azure Stream Analytics query. (Exhibi...
Question 34: You need to build a solution to collect the telemetry data f...
Question 35: A company has a SaaS solutions that will uses Azure SQL Data...
Question 36: Use the following login credentials as needed: Azure Usernam...
Question 37: (Exhibit) Use the following login credentials as needed: Azu...
Question 38: A company plans to use Azure SQL Database to support a missi...
Question 39: You need to replace the SSIS process by using Data Factory. ...
Question 40: On which data store you configure TDE to meet the technical ...
Question 41: Which masking functions should you implement for each column...
Question 42: You need to set up Azure Data Factory pipelines to meet data...
Question 43: You are developing the data platform for a global retail com...
Question 44: You need to implement event processing by using Stream Analy...
Question 45: You develop data engineering solutions for a company. An app...
Question 46: Your company uses Microsoft Azure SQL Database configure wit...
Question 47: Use the following login credentials as needed: Azure Usernam...
Question 48: A company builds an application to allow developers to share...
Question 49: A company plans to use Azure Storage for file storage purpos...
Question 50: Note: This question is part of a series of questions that pr...