nerdexam
Microsoft

AZ-400 · Question #86

Case Study 2 - Contoso, Ltd Background Contoso, Ltd. is a manufacturing company that has a main office in Chicago. Contoso plans to improve its IT development and operations processes by implementing

The correct answer is B. BACPAC. BACPAC is the correct answer because it is a file format used to export Azure SQL databases, containing both the database schema and data, making it ideal for migrating or archiving SQL databases in Azure environments. BACPAC files are the standard Azure-supported format for SQL

Submitted by tom_us· Mar 6, 2026Implement and manage Azure database solutions, including selecting appropriate file formats for SQL database export and migration in Azure environments

Question

Case Study 2 - Contoso, Ltd Background Contoso, Ltd. is a manufacturing company that has a main office in Chicago. Contoso plans to improve its IT development and operations processes by implementing Azure DevOps principles. Contoso has an Azure subscription and creates an Azure DevOps organization. The Azure DevOps organization includes: The Docker extension A deployment pool named Pool7 that contains 10 Azure virtual machines that run Windows Server 2016 The Azure subscription contains an Azure Automation account. Contoso plans to create projects in Azure DevOps as shown in the following table. Technical requirements Contoso identifies the following technical requirements: Implement build agents for Project1. Whenever possible, use Azure resources. Avoid using deprecated technologies. Implement a code flow strategy for Project2 that will: - Enable Team2 to submit pull requests for Project2. - Enable Team2 to work independently on changes to a copy of Project2. - Ensure that any intermediary changes performed by Team2 on a copy of Project2 will be subject to the same restrictions as the ones defined in the build policy of Project2. Whenever possible implement automation and minimize administrative effort. Implement Project3, Project5, Project6, and Project7 based on the planned changes Implement Project4 and configure the project to push Docker images to Azure Container Registry. Drag and Drop Question You need to recommend a procedure to implement the build agent for Project1. Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Exhibit

AZ-400 question #86 exhibit

Options

  • ANDF
  • BBACPAC
  • CBACPAK
  • DMDF

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    91% (20)
  • D
    5% (1)

Explanation

BACPAC is the correct answer because it is a file format used to export Azure SQL databases, containing both the database schema and data, making it ideal for migrating or archiving SQL databases in Azure environments. BACPAC files are the standard Azure-supported format for SQL Database import/export operations and avoid deprecated technologies. This aligns with Contoso's requirement to use Azure resources wherever possible.

Topics

#Azure SQL Database#Database Migration#BACPAC#Azure DevOps

Community Discussion

No community discussion yet for this question.

Full AZ-400 Practice