ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 3 question 96 discussion

Actual exam question from Microsoft's 70-765
Question #: 96
Topic #: 3
[All 70-765 Questions]

You have a Microsoft Azure SQL database in the US West region.
You need to create a replica in the US East region.
Which cmdlet should you run first?

  • A. New-AzureRmAvailabilitySet
  • B. New-AzureRmLoadBalancer
  • C. New-AzureRmSqlDatabaseSecondary
  • D. New-AzureRmSqlElasticPool
  • E. New-AzureRmVM
  • F. New-AzureRmSqlServer
  • G. New-AzureRmSqlDatabaseCopy
  • H. New-AzureRmSqlServerCommunicationLink
Show Suggested Answer Hide Answer
Suggested Answer: G 🗳️
Expalantion:
The New-AzureRmSqlDatabaseCopy command creates a copy of a SQL Database that uses the snapshot at the current time.
References: https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabasecopy?view=azurermps-5.1.1
by manman at July 18, 2019, 2:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
manman
Highly Voted 6 years ago
Answer C: The New-AzureRMSqlDatabaseSecondary cmdlet replaces the Start-AzureSqlDatabaseCopy cmdlet when used for setting up geo-replication for a database. It returns the geo-replication link object from the primary to the secondary database
upvoted 5 times
MelKr
5 years, 2 months ago
The questions does not state that there will be a permanent replication between the two databases so I would prefer G
upvoted 1 times
KC
5 years, 1 month ago
In the context of the question, isn’t a replica used specifically for continued replication? Otherwise, they’d have used the term “copy”.
upvoted 1 times
...
...
...
rohithravindran
Most Recent 4 years, 9 months ago
C. New-AzureRmSqlDatabaseSecondary is the right answer
upvoted 2 times
...
RohitRaj2311
4 years, 9 months ago
C is correct. https://docs.microsoft.com/en-us/powershell/module/az.sql/new-azsqldatabasesecondary?view=azps-4.7.0
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel