nerdexam
Microsoft

PL-400 · Question #348

Case Study 7 - Northwind Traders Background Northwind Traders uses Microsoft Dynamics 365 Sales to manage its sales process. To better understand its customers, Northwind Traders invests in a team of

The correct answer is A. The web service lacks data for the record.. The failure to enrich a Dynamics 365 account record from an Azure SQL Database is likely due to the external web service lacking the specific data for the requested record.

Submitted by klara.se· Apr 18, 2026

Question

Case Study 7 - Northwind Traders Background Northwind Traders uses Microsoft Dynamics 365 Sales to manage its sales process. To better understand its customers, Northwind Traders invests in a team of researchers who gather data from multiple sources. The company stores the data it collects in a Microsoft Azure SQL Database. The company plans to use the data to enrich account records and make the sales team more effective. Current environment Environment - The company has three Microsoft Power Platform environments with Dynamics 365 Sales installed. The environments are named development, test, and production. - Each environment has an application user that can be used for integrations. - The company must use solutions to perform all customization and configuration deployment. Data - Researchers are responsible for creating account records. - Researchers have permissions on the Account table to create records, read all records, and update records they own. - A synchronous plug-in runs when an account record is created and could reassign the record to a different user. - Users must access data as themselves to enforce security and audit changes. - A column named new_dataid is added to the Account table. The column uniquely identifies which data it should receive. - Researchers have researched only the top 20 percent of account records. Web API - The company creates an Azure Function to run a RESTful .NET Web API. - Data can be retrieved by placing a GET request to the URL https://dataservice- [ENVIRONMENTNAME].azurewebsites.net/enrich/[DATAID]. - [ENVIRONMENTNAME] is the name of the Microsoft Power Platform environment that requests the data. - [DATAID] is the new_dataid column in the Account table. • The Web API response will return a 200 response plus data if the DataId is found. Otherwise, a 404 response is returned. • Developers plan to create a custom connector from the Web API to make it accessible from Microsoft Power Platform. Requirements Custom connector - The Web API definition used to create the custom connector must be generated based on a low-code technology. - The URL used by the custom connector must incorporate the current environment name without hardcoding values. - Errors generated by the custom connector must not cause downstream processes to fail. - Text descriptions and field placeholder text that describe the use of the custom connector must appear for non-developers. Process - All account records must be updated with data from the Web API once automatically. - Only account records that contain a DataId should be updated by the Web API. - Researchers must create Power Automate flows to specify data analysis priority. - The researchers require a process that repurposes a set of identical steps of parameterized Microsoft Dataverse queries from a Power Automate flow for use in other flows that have different parameters. The researchers want to avoid recreating the steps manually each time they create a flow to save time and avoid errors. Issues - A tester attempts to connect to the production instance of the Web API with a DataId that should return data. The tester receives an error stating that the remote name could not be resolved. - A missing component causes an error to occur when importing the solution that contains the Power Automate flow to update account records in a test environment. You need to determine the cause of the 404 error when connecting to the production instance of the Web API. What do you identify?

Options

  • AThe web service lacks data for the record.
  • BAn authentication error occurred.
  • CThe request timed-out.
  • DThe host name in the URL is missing a valid value.

How the community answered

(29 responses)
  • A
    76% (22)
  • B
    3% (1)
  • C
    14% (4)
  • D
    7% (2)

Why each option

The failure to enrich a Dynamics 365 account record from an Azure SQL Database is likely due to the external web service lacking the specific data for the requested record.

AThe web service lacks data for the record.Correct

If the external web service, which retrieves data from the Azure SQL Database, does not find or possess the necessary data for a particular account record, it will be unable to provide the information required for enrichment. This indicates a data availability or integrity issue in the source system rather than a connectivity or authentication problem.

BAn authentication error occurred.

An authentication error would typically prevent the web service from being accessed at all, affecting all data requests, not specifically indicating a lack of data for a single record.

CThe request timed-out.

A request timeout implies a delay in response from the web service, often due to network issues or slow processing, not necessarily that the data for the record is absent.

DThe host name in the URL is missing a valid value.

A missing or invalid host name in the URL would result in a connection failure at a much earlier stage, preventing any communication with the web service.

Concept tested: Troubleshooting external data integration issues

Community Discussion

No community discussion yet for this question.

Full PL-400 Practice