Prev Next Question 42/99 - 70-764.v2019-09-18

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
* The database schemas must be synchronized from SQLDev to SQLProd.
* The database on SQLDev must be deployed to SQLProd by using a package.
* The package must support being deployed to SQL Azure.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Comments (The most recent comments are at the top.)

- Oct 07, 2019

The correct answer is D - SSIS. Not B.

LEAVE A REPLY

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

Question List (99q)
Question 1: Note: This question is part of a series of questions that pr...
Question 2: Note: This question is part of a series of questions that pr...
Question 3: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 4: You work as a Database Administrator (DBA) for a company nam...
Question 5: You administer a Microsoft SQL Server 2016 server that hosts...
Question 6: You are migrating a database named Orders to a new server th...
Question 7: You administer a SQL Server 2014 instance. Users report that...
Question 8: You have a server named Server1 that has 2 processors. You p...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: Note: This question is part of a series of questions that us...
Question 11: You are troubleshooting an application that runs a query. Th...
Question 12: You plan to install Microsoft SQL Server 2016 for a web host...
Question 13: You create a stored procedure that retrieves all of the rows...
Question 14: Note: This question is part of a series of questions that us...
1 commentQuestion 15: You administer a SQL Server instance. A database named DB1 i...
Question 16: Note: This question is part of a series of questions that us...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: You are a database administrator for a company. Database aud...
Question 19: You have a database named DB1. You plan to create a stored p...
Question 20: You administer a Microsoft SQL Server 2016 instance that has...
Question 21: You administer a Microsoft SQL Server 2016 database. The dat...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: You need to assign security to dev_role1. How should you com...
Question 24: You have four databases that are accessed by using an Online...
Question 25: You have a SQL Server 2014 instance named SQL1. SQL1 creates...
Question 26: Note: This question is part of a series of questions that pr...
Question 27: You manage a database named DB1 that uses the following file...
Question 28: Note: This question is part of a series of questions that us...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You administer a Microsoft SQL Server 2016 server that hosts...
Question 31: You configure the Microsoft SQL Server Agent service to star...
Question 32: Overview General Overview ADatum Corporation has offices in ...
Question 33: You are building a stored procedure for a SQL Azure database...
Question 34: You administer two instances of Microsoft SQL Server 2016. Y...
Question 35: General Overview You are the Senior Database Administrator (...
Question 36: Note: This question is a part of a series of questions that ...
Question 37: Note: This question is part of a series of questions that us...
Question 38: You are the lead database administrator (DBA) of a Microsoft...
Question 39: Note: This question is part of a series of questions that us...
Question 40: Note: This question is part of a series of questions that us...
Question 41: A company has an on-premises Microsoft SOI Server environmen...
1 commentQuestion 42: You have two SQL Server instances named SQLDev and SQLProd t...
Question 43: Note: This question is part of a series of questions that pr...
Question 44: Note: This question is part of a series of questions that pr...
Question 45: You have a test server that contains a database named DB1. B...
Question 46: You administer two servers AO-AG2 and ao-ag2. Microsoft SQL ...
Question 47: Overview General Overview ADatum Corporation has offices in ...
Question 48: Overview You are a database administrator for a company name...
Question 49: You have a SQL Server instance on a server named Server1. Yo...
Question 50: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 51: You administer several Microsoft SQL Server 2016 database se...
Question 52: A company has an on-premises Microsoft SQL Server environmen...
Question 53: Note: This question is part of a series of questions that pr...
Question 54: Note: This question is part of a series of questions that pr...
Question 55: Note: This question is part of a series of questions that us...
Question 56: An organization deploys Microsoft SQL Server instances at a ...
Question 57: Your company has offices in Seattle and Montreal. The networ...
Question 58: You want to simulate read, write, checkpoint, backup, sort, ...
Question 59: You plan to deploy SQL Server 2014. Your company identifies ...
Question 60: You have multiple Microsoft SQL Server databases that are de...
Question 61: You have a table that contains a column named Department. Ea...
Question 62: You have a SQL Server 2012 database named DB1. You have a ba...
Question 63: You maintain three datacenters in different geographical reg...
Question 64: Background Corporate Information Fabrikam, Inc. is a retaile...
Question 65: You manage a Microsoft SQL Server instance that has a databa...
Question 66: Note: This question is part of a series of questions that pr...
Question 67: You are creating a database that will store usernames and cr...
Question 68: You administer a Microsoft SQL Server 2016 instance. After a...
Question 69: You manage a Microsoft SQL Server environment with a databas...
Question 70: You have a database hosted on SQL Server 2012 R2. The databa...
Question 71: You have a database that stores information for a shipping c...
Question 72: Overview Application Overview Contoso, Ltd., is the develope...
Question 73: Note: This question is part of a series of questions that pr...
Question 74: Note: This question is part of a series of questions that us...
Question 75: You create an availability group that has replicas named HA/...
Question 76: Overview You are a database administrator for a company name...
Question 77: Overview General Overview ADatum Corporation has offices in ...
Question 78: You need to validate rows before they are added to a table e...
Question 79: Note: This question is part of a series of questions that us...
Question 80: You manage a Microsoft SQL Server environment. You plan to e...
Question 81: You are planning the deployment of two new Always On Failove...
Question 82: Note: This question is part of a series of questions that us...
Question 83: You work as a Developer at ABC.com. All databases are hosted...
Question 84: You work as a Database Administrator (DBA) for a company nam...
Question 85: You are implementing a SQL Server 2016 five-node failover cl...
Question 86: You administer two Microsoft SQL Server 2012 servers. Each s...
Question 87: You administer a Microsoft SQL Server 2016 database. You pro...
Question 88: You are configuring log shipping for a Microsoft SQL Server ...
Question 89: Note: This question is part of a series of questions that us...
Question 90: Note: This question is part of a series of questions that us...
Question 91: Note: This question is part of a series of questions that pr...
Question 92: You administer a Microsoft SQL Server 2016 database named Or...
Question 93: You have a Microsoft SQL Server instance that hosts a databa...
Question 94: Note: This question is part of a series of questions that pr...
Question 95: Note: This question is part of a series of question that pre...
Question 96: You have a SQL Azure database named Database1. You need to d...
Question 97: You administer a Microsoft SQL Server 2016 database that con...
Question 98: You have a database named DB1. You must ensure that DB1 is h...
Question 99: You install Microsoft SQL Server 2016 on a new server. After...