Viele Leute, die in der IT-Branche arbeiten, wissen die mühsame Vorbereitung auf die Microsoft DP-800 Prüfung. Wir ZertPruefung können doch den Schwierigkeitsgrad der Microsoft DP-800 Prüfung nicht ändern, aber wir können die Schwierigkeitsgrad der Vorbereitung für Sie vermindern. Ihre Angst vor der Microsoft DP-800 Prüfung wird beseitigen, solange Sie die Prüfungsunterlagen von unserem Technik-Team probiert haben. Wir tun unser Bestes, um Ihnen zu helfen, Ihre Konfidenz für Microsoft DP-800 zu verstärken!
| Thema | Einzelheiten |
|---|---|
| Thema 1 |
|
| Thema 2 |
|
| Thema 3 |
|
>> DP-800 Zertifizierungsantworten <<
Die Fragenpool zur Microsoft DP-800 Zertifizierungsprüfung von ZertPruefung werden nach dem gleichen Lernplan bearbeitet. Wir aktualisieren auch ständig unsere Fragenpool, die Prüfungsragen und Antworten enthalten. Weil unsere Prüfungen den echten Prüfungen sehr änlich sind, ist unsere Erfolgsquote auch sehr hoch. Diese Tatsache ist nicht zu leugnen, Unsere Fragenpool zur Microsoft DP-800 Zertifizierung können den Kandidaten sehr helfen. Und unser Preis ist ganz rational, was jedem IT-Kandidaten passt.
75. Frage
You have an Azure SQL database that contains a table named Tickets_Embeddings.
Tickets_Embeddings contains a VECTOR(1536) column.
Embeddings are generated by using text-embedding-ada-002 and the /openai/v1/embeddings endpoint.
After a review of the current environment, the following changes are requested:
- The AI architect has recommended switching to text-embedding-3-small.
- The security team requires authentication by using Microsoft Entra
managed identities only. Storing API keys in an application is
prohibited.
Which two actions should you include in the solution? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Antwort: A,D
Begründung:
To migrate your Azure SQL database to use the text-embedding-3-small model while implementing Microsoft Entra managed identity authentication, you should take the following actions:
[B]
Regenerate all the embeddings: Even though text-embedding-ada-002 and the default configuration of text-embedding-3-small both use 1,536 dimensions, the underlying vector representations are mathematically incompatible. Comparing an "ada" vector to a "v3-small" vector using cosine similarity will yield incorrect results. You must re-embed your existing data using the new model to maintain search accuracy.
[C]
Change the endpoint: To switch models, you must update your application code or database configuration (such as an AI_GENERATE_EMBEDDINGS function call or a stored procedure) to point to the new Azure OpenAI deployment endpoint for text-embedding-3-small.
Why these actions are necessary:
Incompatibility: Vectors generated by different models exist in different latent spaces. While you do not need to Alter the database tables (since the VECTOR(1536) column type remains identical for both models), the actual data inside those columns must be replaced.
Managed Identity: To meet the requirement of using Microsoft Entra managed identities and prohibiting API keys, you must configure your application or the Azure SQL DB to authenticate with Azure OpenAI using a managed identity. This involves granting the identity the Cognitive Services OpenAI User role and updating your connection strings/calls to exclude the api-key header.
Reference:
https://microsoftlearning.github.io/mslearn-postgresql/Instructions/Labs/13-generate-vector- embeddings-azure-openai.html
76. Frage
Vou have a Microsoft Fabric workspace named Workspace1 that contains a SQL database named SalesDB and an API for GraphQL tern named SalesApi.
You have a Microsoft Entra group named SqlUsers.
From Workspace1, you assign permission to SalesApi as shown in the following exhibit.
The connection to SalesDB has the connectivity option configured as shown in the following exhibit.
SqlUsers has the Viewer role for Workspace1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Antwort:
Begründung:
Explanation:
* The members of SqlUsers can modify the data in SalesDB via SalesApi. # No
* The members of SqlUsers can view the data in SalesDB via SalesApi. # No
* The members of SqlUsers can change the field mappings of SalesApi. # Yes For both viewing and modifying data through SalesApi, the key missing permission is Run Queries and Mutations . Microsoft's Fabric GraphQL documentation states that callers need Execute permissions for the GraphQL API , which correspond to the Run Queries and Mutations option, and with SSO connectivity they also need appropriate permissions on the underlying data source. In the exhibit, SqlUsers has View and Edit GraphQL item selected, but Run Queries and Mutations is not selected, so members cannot query or mutate data through the API.
The third statement is Yes because the group was explicitly granted View and Edit GraphQL item . That permission is the one that allows users to open and modify the GraphQL item itself, including schema-related configuration such as field mappings in the API item. The workspace Viewer role does not by itself grant query execution through the API, but the direct GraphQL item permission shown does allow editing the item.
77. Frage
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an SDK-style SQL database project stored in a Git repository. The project targets an Azure SQL database.
The CI build fails with unresolved reference errors when the project references system objects.
You need to update the SQL database project to ensure that dotnet build validates successfully by including the correct system objects in the database model for Azure SQL Database.
Solution: Add the Microsoft.SqlServer.Dacpacs.Master NuGet package to the project.
Does this meet the goal?
Antwort: A
Begründung:
Correct:
* Add the Microsoft.SqlServer.Dacpacs.Azure.Master NuGet package to the project.
To resolve system reference errors in an SDK-style SQL project targeting Azure SQL Database, you need to add a reference to the Microsoft.SqlServer.Dacpacs.Azure.Master NuGet package.
In your .sqlproj file, include the following item group:
<ItemGroup>
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Azure.Master" Version="1.60.0" />
</ItemGroup>
Why this works:
System Objects: Standard SDK-style projects don't automatically include system views (like sys.database_principals or sys.dm_db_resource_stats). This package provides the necessary metadata for the compiler.
Azure Specifics: It includes Azure-only system objects that aren't present in the standard master database dacpac used for on-premises SQL Server.
CI/CD Friendly: Since it is a NuGet package, the dotnet build command will automatically restore it during the CI process without requiring manual file paths or local installations of Visual Studio.
Incorrect:
* Add an artifact reference to the Azure SQL Database master.dacpac file.
* Add the Microsoft.SqlServer.Dacpacs.Master NuGet package to the project.
Reference:
https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/concepts/system-objects
78. Frage
Vou have a SQL database in Microsoft Fabric that contains a nvarchar(max) column named MessageText. An ID is always contained within the first paragraph of MessageText.
You need to write a Transact SQL query that uses REGEXP_SUBSTR to extract the ID from MessageText.
What should you include in the query?
Antwort: C
Begründung:
Microsoft documents REGEXP_SUBSTR for Transact-SQL with the string_expression parameter as supporting character string types char, nchar, varchar, and nvarchar. For the regex functions, support for LOB types such as varchar(max) and nvarchar(max) is specifically called out for REGEXP_LIKE , REGEXP_COUNT , and REGEXP_INSTR up to 2 MB, but that support note is not listed for REGEXP_SUBSTR in the surfaced documentation. In exam terms, the safe and expected approach is to cast the nvarchar(max) column to nvarchar(4000) before calling REGEXP_SUBSTR.
This also fits the scenario detail that the ID is always contained within the first paragraph of MessageText.
Since the needed value is near the start of the text, narrowing the input to a non-LOB string type such as nvarchar(4000) is sufficient and avoids incompatibility concerns with nvarchar(max).
The other options are not appropriate:
* A STRING_ESCAPE(..., ' json ' ) is for JSON escaping, not regex extraction.
* C adding a case-sensitive collation changes comparison behavior, but it is not the required fix for REGEXP_SUBSTR on nvarchar(max).
* D TRY_CONVERT(varchar(max), ...) still leaves a MAX type and also risks unnecessary Unicode loss.
79. Frage
You have a SQL database in Microsoft Fabric named Sales BD that contains a table named dbo.Products. You need to modify SalesBD to meet the following requirements:
* Create a vector index on the appropriate column.
* Use a supplied natural language query vector.
How should you complete the Transact-SQL code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Antwort:
Begründung:
Explanation:
The first correct selection is embedding because a vector index must be created on the vector column , not on a scalar distance column or a text column such as product_name. Microsoft's CREATE VECTOR INDEX documentation shows that the index is created directly on the vector-valued column, for example ON product_embeddings(embedding).
The second correct selection is VECTOR_SEARCH because the requirement is to use a supplied natural language query vector and search against the indexed embeddings. Microsoft documents that VECTOR_SEARCH is the Transact-SQL function for approximate nearest neighbor vector retrieval and that it applies to SQL database in Microsoft Fabric as well as other supported SQL platforms.
This also matches the shown code pattern:
* declare a vector variable such as @query_vector VECTOR(1536),
* create a vector index on dbo.Products(embedding),
* query with VECTOR_SEARCH(... SIMILAR_TO = @query_vector, METRIC = ' cosine ' , TOP_N =
10).
80. Frage
......
Mit Microsoft DP-800 Zertifikat können Sie Ihre Berufsaussichten verbessern und viele neuen Chancen erschließen. ZertPruefung ist eine geeignete Website für die Kandidaten, die an der Microsoft DP-800 Zertifizierungsprüfung teilnehmen. Es wird nicht nur alle Informationen zur Microsoft DP-800 Zertifizierungsprüfung, sondern Ihnen auch eine gute Lernchance bieten. ZertPruefung wird Ihnen helfen, die Microsoft DP-800 Zertifizierungsprüfung ganz einfach zu bestehen.
DP-800 Examengine: https://www.zertpruefung.ch/DP-800_exam.html