<< Prev Question Next Question >>

Question 35/75

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From Microsoft SQL Server Management Studio (SSMS), you rename Database1 on Server2 as Database2. From the Azure portal, you create a new database on Server2 by restoring the backup of Database1 from Server1, and then you delete Database2.
Does this meet the goal?

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...