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

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to Exam

Exam DP-900 topic 1 question 88 discussion

Actual exam question from Microsoft's DP-900
Question #: 88
Topic #: 1
[All DP-900 Questions]

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

  • A. built-in high availability
  • B. native support for cross-database queries and transactions
  • C. system-initiated automatic backups
  • D. support for encryption at rest
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by jasu at Sept. 9, 2020, 10:45 a.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
jasu
Highly Voted 4 years, 1 month ago
Reference document https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
upvoted 47 times
...
cadio30
Highly Voted 3 years, 1 month ago
B is the correct answer "native support for cross-database queries and transactions"
upvoted 25 times
...
AGTraining
Most Recent 8 months ago
option B
upvoted 1 times
...
Ycombo
10 months, 3 weeks ago
How many pages or Qs should I atleast go thorugh to be confident that I have covered enough, I am at Page 17 atm ?
upvoted 1 times
Anna_Le
10 months, 1 week ago
better go through all of the questions:)
upvoted 4 times
...
...
Kans19
1 year, 5 months ago
Selected Answer: B
ACD are available for both SQL db and SQL managed instance. While multiple writes and reads for SQL managed instance and only multi read alone is available for SQL db. So it's B
upvoted 2 times
...
GaneshNats
1 year, 6 months ago
Selected Answer: B
B is the right answer
upvoted 3 times
...
chiiiweiii
1 year, 7 months ago
Selected Answer: B
Correct Answer
upvoted 2 times
...
Dusica
1 year, 11 months ago
B; other 3 are all in common for all SQL databases
upvoted 5 times
...
JA2018
2 years ago
Selected Answer: B
Right response
upvoted 3 times
...
SiDoCiOuS
2 years, 7 months ago
Selected Answer: B
Appeared on the exam on 03/22/2022 Answer is correct!
upvoted 4 times
...
Koph
2 years, 10 months ago
Tricky one but B is correct
upvoted 4 times
...
bluetail
2 years, 11 months ago
No, it is D) support for encryption at rest. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
upvoted 1 times
iooj
2 years, 9 months ago
No. TDE available in both. "B" is the correct answer. See here: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
upvoted 4 times
...
...
Gbolatiti
3 years ago
I just passed this exam now...this question came out
upvoted 9 times
...
UniversalSoldier
3 years, 2 months ago
Answer is correct, search cross-database on the below link https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
upvoted 4 times
...
Adebowale
3 years, 2 months ago
Good analysis and reference
upvoted 1 times
...
Crazy_Angel
3 years, 4 months ago
Cross-database/three-part name queries Yes, plus Elastic queries Cross-database transactions Yes, within the instance. Hence, I think B is the answer. native support for cross-database queries and transactions
upvoted 1 times
...
razxssd
3 years, 4 months ago
Ciao Ale, Iso, Ale
upvoted 2 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago