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 303 discussion

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

HOTSPOT -

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by Teryyyy at April 23, 2024, 2:18 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
Andrewwfw
Highly Voted 11 months, 2 weeks ago
Answer is YNN 1. Azure SQL Managed support cross-DB queries three-part name queries 2. Elastic pools are used to manage and scale multiple databases with varying workloads on Azure SQL Database, not SQL Server on Azure Virtual Machines. 3. SQL DB Supported on both Physical & VMs (Not Azure SQL)
upvoted 16 times
Andrewwfw
11 months, 1 week ago
3. SQL Managed
upvoted 3 times
...
Andrewwfw
11 months, 2 weeks ago
2. The databases in an elastic pool are on a single server and share a set number of resources https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
upvoted 1 times
...
...
man5484
Most Recent 3 months, 1 week ago
Yes: Azure SQL Managed Instance allows hosting multiple databases within the same instance. Cross-database queries are supported, enabling seamless data access between databases within the same managed instance. No: Elastic pools are used in Azure SQL Database to share resources across multiple databases, not across SQL Server instances on Azure VMs. Azure VMs do not use elastic pools. No: Azure SQL Database is highly compatible with SQL Server but not fully compatible. Some SQL Server features, such as SQL Server Agent and cross-database transactions, are not supported in Azure SQL Database. Full compatibility is achieved with Azure SQL Managed Instance, not Azure SQL Database.
upvoted 2 times
...
profesorklaus
7 months, 3 weeks ago
Answer is YNN 1. Azure SQL Managed Instances support multiple databases, and cross-database queries are possible within the instance. 2. Elastic pools in Azure SQL are used to share resources across multiple Azure SQL databases, but not across SQL Server instances on Azure Virtual Machines. 3. Azure SQL Database is a managed platform-as-a-service (PaaS) offering that doesn't have full compatibility with on-premises or virtualized SQL Server instances due to some differences in features and capabilities.
upvoted 2 times
...
danielaestevao93
10 months, 2 weeks ago
YNN is correct
upvoted 2 times
...
Teryyyy
1 year ago
i think YYN
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago