DP-800問題集はオンライン版、ソフト版、とPDF版がありますので、とても便利です。DP-800問題集を購入すれば、あなたはいつでもどこでも勉強することができます。DP-800問題集はIT専門家が長年の研究したことです。従って、高品質で、DP-800試験の合格率が高いです。毎年、たくさんの人がDP-800試験に参加し、合格しました。あなたはDP-800問題集を利用すれば、DP-800試験に合格できますよ。もし、将来に、IT専門家になります。
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Implement AI capabilities in database solutions (25–30%) | 25-30% | - Integrate Azure AI services
|
| Topic 2: Design and develop database solutions (35–40%) | 35-40% | - Implement data management
|
| Topic 3: Secure, optimize, and deploy database solutions (35–40%) | 35-40% | - Implement data platform resources
|
他人の気付いていないときに、だんだんMicrosoftのDP-800試験成功したいのですか？我が社はIT資格認証試験資料の販売者として、いつまでもできご客様に相応しく信頼できるDP-800問題集を提供できます。あなたのすべての需要を満たすためには、一緒に努力します。躊躇われずに我々の模試験を利用してみてください。全力を尽くせば、DP-800試験の合格も可能となります。
質問 # 13
You have an Azure subscription. The subscription contains an Azure SQL database named SalesDB and an Azure App Service app named sales-api. sales-api uses virtual network integration to a subnet named vnet- prod/subnet-app and reads from SalesDB You need to configure authentication and network access to meet the following requirements:
* Ensure that sales-api connects to SalesDB by using passwordless authentication.
* Ensure that all the database traffic remains within the subscription.
The solution must minimize administrative effort
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
For authentication , the correct choice is Enable a managed identity and use Microsoft Entra authentication . Azure App Service supports managed identity, and Microsoft documents this as the recommended way to connect to Azure SQL Database without passwords or secrets . This minimizes administrative effort because there are no SQL passwords to rotate, store, or manage.
For network access , the correct choice is Create a private endpoint and disable public network access .
Microsoft documents that when public network access is disabled , Azure SQL Database only accepts connections through private endpoints . That keeps the database traffic on Azure private networking rather than exposing it through the public endpoint. Microsoft also notes that simply adding a private endpoint does not disable public access by itself, so disabling public network access is part of the correct configuration.
The other options are weaker:
* Rotated SQL credentials or storing SQL logins in Key Vault still use passwords and create more admin overhead.
* Allowing Azure services, adding outbound IP firewall rules, or database firewall rules still rely on the public endpoint , so they do not best satisfy the requirement that database traffic remain within the subscription.
質問 # 14
You have a SQL database in Microsoft Fabric that contains a table named dbo.Orders, dbo.Orders has a clustered index, contains three years of data, and is partitioned by a column named OrderDate by month.
You need to remove all the rows for the oldest month. The solution must minimize the impact on other queries that access the data in dbo.orders.
Solution; Identify the partition scheme (or the oldest month, and then run the following Transact-SQL statement.
ALTER TABLE dbo.Orders
DROP PARTITION SCHEME (partition_scheme_name);
Does this meet the goal?
正解：B
解説：
This also does not meet the goal. DROP PARTITION SCHEME removes the partition scheme object from the database; it is not the command used to remove just the rows for the oldest month from a partitioned table.
Microsoft's DROP PARTITION SCHEME documentation is explicit that the statement removes the partition scheme itself.
For removing only the oldest month's rows with minimal impact, Microsoft points to partition-level maintenance operations such as truncating a single partition on a partitioned table. That targets only the needed data subset and is more efficient for retention workloads.
質問 # 15
You have a SQL database in Microsoft Fabric that contains a column named Payload. pay load stores customer data in JSON documents that have the following format.
Data analysis shows that some customers have subaddressing in their email address, for example, user1+promo@contoso.com.
You need to return a normalized email value that removes the subaddressing, for example, user! + promo@contoso.com must be normalized to userl@contoso.com.
Which Transact SQL expression should you use?