AB-400 Practice Questions

You develop the following code for a console application that performs the data import to Microsoft Dataverse.

01        CrmServiceClient service = new CrmServiceClient(connectionString);

02

03        if (!service.IsReady)

04        {

05                    Console.WriteLine(service.LastCrmError);

06                    Console.ReadLine();

07                    return;

08        }

09

10        ExecuteMultipleRequest executeMultipleRequest = new ExecuteMultipleRequest()

11        {

12                    Settings = new ExecuteMultipleSettings()

13                    {

14                                ContinueOnError = false,

15                                ReturnResponses = true

16                    },

17                    Requests = new OrganizationRequestCollection()

18        };

19 

20        executeMultipleRequest.Requests.Add(new CreateRequest()

21        {

22                    Target = new Entity("account")

23                    {

24                                ["name"] = "Contoso",

25                                ["accountnumber"] = "ACC-0000001"

26                    },

27                    ["SuppressDuplicateDetection"] = false

28        });

29 

30        executeMultipleRequest.Requests.Add(new CreateRequest()

31        {

32                    Target = new Entity("contact")

33                    {

34                                ["firstname"] = "John",

35                                ["lastname"] = "Doe",

36                    }

37        });

38 

39        ExecuteMultipleResponse executeMultipleResponse = (ExecuteMultipleResponse)service.Execute(executeMultipleRequest);

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

NOTE: Each correct selection is worth one point.

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 on the review screen.

A company develops a Power Apps code app that integrates with a SQL Server database. The connection information will change based on the environment, so any values will be stored in an environment variable.

You plan to use the Power Apps CLI to add the SQL Server connection to the code app.

The command must meet the following criteria:

 

• Read the current environment-specific value(s).
• Account for the possibility of different server and table names.
• Continue working when deployed to different environments.

You need to create the command.

Solution: pac code add-data-source -a "<apiId>" -c "<connectionId>" -d "myserver.database.windows.net,mydatabase" -t "sqltablename"

Does the solution meet the goal?

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 on the review screen.

A company develops a Power Apps code app that integrates with a SQL Server database. The connection information will change based on the environment, so any values will be stored in an environment variable.

You plan to use the Power Apps CLI to add the SQL Server connection to the code app.

The command must meet the following criteria:

 

• Read the current environment-specific value(s).
• Account for the possibility of different server and table names.
• Continue working when deployed to different environments.

You need to create the command.

Solution: pac code add-data-source -a "<apiId>" -c "<connectionId>" -d "crd1b_SQLConnection" -t "crd1b_SQLTableName"

Does the solution meet the goal?

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 on the review screen.

A company develops a Power Apps code app that integrates with a SQL Server database. The connection information will change based on the environment, so any values will be stored in an environment variable.

You plan to use the Power Apps CLI to add the SQL Server connection to the code app.

The command must meet the following criteria:

 

• Read the current environment-specific value(s).
• Account for the possibility of different server and table names.
• Continue working when deployed to different environments.

You need to create the command.

Solution: pac code add-data-source -a "<apiId>" -c "<connectionId>" -d "@envvar:crd1b_SQLConnection" -t "@envvar:crd1b_SQLTableName"

Does the solution meet the goal?

Users are directed to a form in a model-driven app through a special URL that passes values for three lookup columns.

The form consists of three tabs: A, which is the default tab, B, and C. The form has JavaScript code registered on the OnLoad and OnSave events as follows:

• OnLoad: A lookup column on each tab is used to retrieve data. The data is used to populate columns on that same tab.
• OnSave: Data validation involves calculations of columns on the form. If a value is outside the acceptable range, the record must not be saved.

Users report that loading and saving the form takes too long when they create a new record.

You need to shorten the time it takes to load and save the form without losing functionality.

Which new event registrations should you create? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You manage a Microsoft Power Automate cloud flow that uses a List rows action to query data from the Accounts table. The Accounts table contains more than 15,000 rows.

You must develop automation that meets the following requirements:

 

• Manage a large number of records.
• Return information from related contact records.

You need to configure the cloud flow to return the information.

Which properties should you configure? To answer, move the appropriate properties to the correct requirements. You may use each property once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.