DRAG DROP
You administer an Azure SQL database named contosodb that is running in Standard/Si tier.
The database is in a server named server1 that is a production environment. You also
administer a database server named server2 that is a test environment. Both database
servers are in the same subscription and the same region but are on different physical clusters.
You need to copy contosodb to the test environment.
Which three steps should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
Answer: 
Explanation:
answer not Correct
You need to copy contosodb to the test environment.
1- Use Dbcopy to Create a copy of database Contosodb in server 1 named Conotosotemp
http://msdn.microsoft.com/en-us/library/azure/ff951631.aspx
2- Export Conotosotemp in server1 to Bacpac file in Azure Blob storage
3- import Bccpac file to the server 2 as ConotosoDB
I believe that you are correct.
Correct Sir + Thanks
+1
is this correct?
– Export contosodbtmp in server1 to a BACPAC file in Azure Blob storage
– Import the BACPAC file to server2 as contosodb
– Scale contosodb in server2 to Standard/S1
http://msdn.microsoft.com/en-us/library/azure/hh335292.aspx
Server1and server2same subscrubtion
Why should i– Scale contosodb in server2 to Standard/S1
i think castortray is correct.
Mohamed right, why scale??
directly exporting a DB can fail while importing as transactional consistency cannot be guaranteed. So either first create a Copy and then export to BACPAC file or if the Automated Export is configured it internally does the same so just get the BACPAC file.
In this case you need to copy the database first and then export to BACPAC and then import as Test.
I believe this is wrong. The scenario and question says we much “copy” and this answer does not use copy!
I think this might be correct. When you import a DB into Azure, the default is to create it as Standard/S2, so you either have to scale the DB during import or afterwards.
You have to do the same with importing with SQL Management studio, I’ve just run a test using both methods.
… But then, the option DOES say to export contosodbtmp rather then contosodb, So I guess Mohammad is more likely correct and Microsoft assumes that you will scale during import.
Mohammed is right!!
I think Mohammed is right.
you may need to create Contosodbtmp database first.
The provided answer is incorrect. Mohammed is right cuz there is no mention of an existence of a DB called contosodbtmp in any of the subscriptions, so how are we exporting it to a BACPAC file in the first place. Answer is to create the tmpDB first then export to BACPAC and import the BACPAC file and rename the DB.
I believe it’s 3,6, 5
3- Use DB copy to create a copy of contosoDB named contosotmp on server1
6- Export it to BACPAC
5- Import the BACPAC to server2 as contosoDB
first response on top is correct. that is what my research also shows
Answer is in line with 70-533 training book:
Use Dbcopy to Create a copy of database Contosodb in server 1 named Conotosotemp
Export Conotosotemp in server1 to Bacpac file in Azure Blob storage
Import Bccpac file to the server 2 as ConotosoDB
There is a clue in the answers provided.
We all know we have to EXPORT right? – well we need to do step “Export Conotosotemp in server1 to Bacpac file in Azure Blob storage” … so we get “Conotosotemp”. We then assume we’d need to do step “Use Dbcopy to Create a copy of database Contosodb in server 1 named Conotosotemp” first to give us the file to be exported to Azure Storage – makes sense?
The steps that Mohammad listed is correct.
However, in addition to the DBCopy and the bacpac export+import, isn’t https://azure.microsoft.com/en-us/documentation/articles/sql-database-copy/ an easier way of doing it from the portal?
I know these steps aren’t mentioned in the answer choices, but does this limit the option because the question states, “but are on different physical clusters”.
What is the significance of- “but are on different physical clusters”?
Assuming copying Database in portal implements “DB Copy.” When using Db Copy, the service tier of the database copy is the same as the source database (https://azure.microsoft.com/en-us/documentation/articles/sql-database-copy/)