<< Prev Question Next Question >>

Question 46/75

You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
Support user-initiated backups.
Support multiple automatically replicated instances across Azure regions.
Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

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

Question List (75q)
Question 1: You have an Azure SQL database. You are reviewing a slow per...
Question 2: You are planning the migration of the SERVER1 databases. The...
Question 3: You have an Azure SQL database. You identify a long running ...
Question 4: You have SQL Server 2019 on an Azure virtual machine that ru...
Question 5: You have an Azure SQL database. Users report that the execut...
Question 6: You have a SQL pool in Azure Synapse that contains a table n...
Question 7: You have an Azure SQL managed instance named SQL1 and two Az...
Question 8: Note: This question is part of a series of questions that pr...
Question 9: What should you use to migrate the PostgreSQL database?...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: You have the following Azure Resource Manager template. (Exh...
Question 12: You have an Azure SQL database named DB1. You need to ensure...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: You have SQL Server on an Azure virtual machine that contain...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: You have the following Transact-SQL query. (Exhibit) Which c...
Question 17: You are monitoring an Azure Stream Analytics job. You discov...
Question 18: Which counter should you monitor for real-time processing to...
Question 19: You are creating a managed data warehouse solution on Micros...
Question 20: You create five Azure SQL Database instances on the same log...
Question 21: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 22: Based on the PaaS prototype, which Azure SQL Database comput...
Question 23: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 24: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 25: You have an Azure subscription that contains an Azure Data F...
Question 26: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 27: You have SQL Server on Azure virtual machines in an availabi...
Question 28: You have an Azure SQL database. The database contains a tabl...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 31: You have an Azure SQL database named db1. You need to retrie...
Question 32: You have an Azure SQL database that contains a table named C...
Question 33: Your company uses Azure Stream Analytics to monitor devices....
Question 34: You are designing an enterprise data warehouse in Azure Syna...
Question 35: Note: This question is part of a series of questions that pr...
Question 36: You have an Azure Synapse Analytics workspace named WS1 that...
Question 37: Note: This question is part of a series of questions that pr...
Question 38: You plan to build a structured streaming solution in Azure D...
Question 39: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 40: You need to design an analytical storage solution for the tr...
Question 41: You are creating a new notebook in Azure Databricks that wil...
Question 42: Note: This question is part of a series of questions that pr...
Question 43: You have an on-premises Microsoft SQL Server 2019 server tha...
Question 44: You have an Azure SQL database. You discover that the plan c...
Question 45: You are designing a star schema for a dataset that contains ...
Question 46: You plan to migrate on-premises Microsoft SQL Server databas...
Question 47: You have an Azure Data Lake Storage Gen2 account named accou...
Question 48: You have an Azure subscription that contains an Azure SQL da...
Question 49: You have an Azure SQL database that contains a table named E...
Question 50: You plan to move two 100-GB databases to Azure. You need to ...
Question 51: A data engineer creates a table to store employee informatio...
Question 52: You have an Azure virtual machine named VM1 on a virtual net...
Question 53: You are developing an application that uses Azure Data Lake ...
Question 54: You have an Azure Data Factory that contains 10 pipelines. Y...
Question 55: You have the following Azure Data Factory pipelines: Ingest ...
Question 56: You have 10 Azure virtual machines that have SQL Server inst...
Question 57: You have SQL Server 2019 on an Azure virtual machine that co...
Question 58: You create all of the tables and views for ResearchDB1. You ...
Question 59: You have an on-premises Microsoft SQL Server 2016 server nam...
Question 60: You have an Azure SQL database named db1 on a server named s...
Question 61: You have an instance of SQL Server on Azure Virtual Machines...
Question 62: A data engineer creates a table to store employee informatio...
Question 63: You have an Azure SQL Database managed instance. The instanc...
Question 64: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 65: You need to trigger an Azure Data Factory pipeline when a fi...
Question 66: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 67: You have SQL Server on an Azure virtual machine. You need to...
Question 68: You have an Azure SQL database named sqldb1. You need to min...
Question 69: You have an Azure SQL managed instance named SQLMI1 that hos...
Question 70: You have an Azure SQL Database managed instance named SQLMI1...
Question 71: You need to recommend an availability strategy for an Azure ...
Question 72: You are designing a dimension table in an Azure Synapse Anal...
Question 73: You have 50 Azure SQL databases. You need to notify the data...
Question 74: From a website analytics system, you receive data extracts a...
Question 75: Note: This question is part of a series of questions that pr...