exam questions

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 5 question 50 discussion

Actual exam question from Microsoft's AZ-304
Question #: 50
Topic #: 5
[All AZ-304 Questions]

You manage an application instance. The application consumes data from multiple databases. Application code references database tables using a combination of the server, database, and table name.
You need to migrate the application data to Azure.
To which two Azure services could you migrate the application to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Azure SQL Managed Instance
  • B. Azure SQL Database
  • C. SQL Server in an Azure virtual machine
  • D. SQL Server Stretch Database
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
somenick
Highly Voted 3 years, 9 months ago
Correct answer is A and C as per https://www.examtopics.com/discussions/microsoft/view/12233-exam-az-301-topic-5-question-10-discussion/
upvoted 22 times
BoxGhost
3 years, 8 months ago
Agreed, linked servers feature only supported on full SQL and MI https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15
upvoted 3 times
examineezer
3 years, 3 months ago
Linked servers arent required here
upvoted 1 times
...
...
...
Snownoodles
Most Recent 2 years, 6 months ago
Selected Answer: AC
Correct answer are AC
upvoted 1 times
...
[Removed]
3 years, 3 months ago
Selected Answer: AC
A C is correct answer
upvoted 1 times
...
Eitant
3 years, 4 months ago
Selected Answer: AC
A & C are the correct answers
upvoted 3 times
...
Dpejic
3 years, 4 months ago
Appere on exam 23-dec-2021
upvoted 3 times
...
donathon
3 years, 4 months ago
Application code references database tables using a combination of the server, database, and table name>> Azure DB cannot do this. You need to migrate the application data to Azure. >> Stretched DB is to stretch the DB from on-prem to Azure. The objective is to move entirely to Azure.
upvoted 4 times
...
chichi0307
3 years, 6 months ago
I think based on "Application code references database tables using a combination of the server, database, and table name" no change in code as the code references database in combination. So answer is D and A
upvoted 1 times
...
tteesstt
3 years, 6 months ago
A and C. Needs multiple databases so B is out.
upvoted 2 times
...
syu31svc
3 years, 6 months ago
"combination of the server, database, and table name" A and C would be the answers
upvoted 1 times
...
souvik123
3 years, 7 months ago
A & C are the correct answers
upvoted 2 times
...
somenick
3 years, 9 months ago
Why not B?
upvoted 1 times
BrettusMaximus
3 years, 9 months ago
B is not correct because it is a single database. You need to have multiple DBs
upvoted 3 times
addam23
3 years, 8 months ago
And B is not the best option in migration case
upvoted 2 times
...
...
...
express
3 years, 9 months ago
A & C are the correct answers.
upvoted 4 times
waxil
3 years, 9 months ago
Why is D incorrect?
upvoted 1 times
BrettusMaximus
3 years, 9 months ago
D is incorrect because a Stretch DB is linked to a single DB in the On-Prem environment and thus would not get all the data
upvoted 6 times
rdemontis
3 years, 5 months ago
I think you're right. thanks for explanation
upvoted 2 times
...
...
...
...
nasa1515
3 years, 9 months ago
should Answer B & D
upvoted 1 times
nasa1515
3 years, 9 months ago
My Mistake. A. SQL Managed Instance C. SQL Server in an Azure virtual machine
upvoted 4 times
...
...
AlanJP
3 years, 10 months ago
Why not 'C' - install SQL on a VM?
upvoted 3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago