exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 50 discussion

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

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

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

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
GK81
Highly Voted 2 years, 2 months ago
where is cross-database query mentioned in the question?
upvoted 12 times
ServerBrain
1 year, 11 months ago
cross-database query mentioned in the question >>>>>>>> "application that consumes data from multiple databases"
upvoted 9 times
...
...
Sanjeevsn
Highly Voted 1 year, 6 months ago
Why not C: AZ SQL?
upvoted 9 times
josola
2 months, 2 weeks ago
You can't reference individual servers. The requirement is that the app will reference data using the triple server, database, and table name.
upvoted 2 times
...
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
Selected Answer: BD
B & D are correct
upvoted 1 times
...
JimmyYop
10 months, 2 weeks ago
appeared in Exam 01/2024
upvoted 4 times
...
NotMeAnyWay
1 year, 5 months ago
Selected Answer: BD
The correct answers are B. SQL Server on an Azure virtual machine and D. Azure SQL Managed Instance. B. SQL Server on an Azure virtual machine allows you to migrate your on-premises SQL Server databases to Azure with very minimal changes to your application. The application code can continue to reference the database tables in the same manner as it did on-premises. D. Azure SQL Managed Instance is a fully-managed SQL Server Database Engine hosted in Azure cloud. It provides near 100% compatibility with the on-premises SQL Server and supports the same server, database, and table naming conventions, which suits the requirement of the application.
upvoted 9 times
...
zellck
1 year, 9 months ago
Selected Answer: BD
BD is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql#features-of-sql-database-and-sql-managed-instance Azure SQL Managed Instance - Cross-database/three-part name queries - Yes
upvoted 3 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: BD
B and D
upvoted 1 times
...
kay000001
2 years, 2 months ago
Selected Answer: BD
B and D.
upvoted 8 times
...
Snownoodles
2 years, 2 months ago
Azure SQL Database also has (virtual) sql server which is global unique. We can also refer a Azure SQL database table by server/database/table. Or the ask of this question is actually about instance features?
upvoted 4 times
Snownoodles
2 years, 2 months ago
Now Azure SQL database also supports cross-database query: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical?view=azuresql
upvoted 3 times
Fal991l
2 years, 1 month ago
question is "The application code references database tables by using a combination of the server, database, and table name"
upvoted 1 times
...
...
...
One111
2 years, 3 months ago
How do we know if there are asking for cross-database queries? Why explanation to given answer is relevant?
upvoted 4 times
Born_Again
2 years ago
"The application code references database tables by using a combination of the server, database, and table name"
upvoted 2 times
...
Jeffab
2 years, 1 month ago
As GK81 also asked, We just don't f..... know! These more recent questions are getting even more ridiculous. If questions like these, which only partially reference published material appear in real exam, then expect us to read between the lines, we have no hope of passing this exam.
upvoted 4 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 ...