AZ-204

 42,43,44,45,46,54,55,56,57,70,71,80,98,99,100,108,104,105,106,192,193,194,209,206,207,210,325,326,327,329,345,346,364,373,351,360,372

42, 43, 44, 45, 46, 54, 55, 56, 57, 70, 71, 80, 98, 99, 100, 104, 105, 106, 108, 192, 193, 194, 206, 207, 209, 210, 325, 326, 327, 329, 345, 346, 351, 360, 364, 372, 373, 399, 400, 401, 403, 404

399 Publish events to an event domain. Create a custom topic for each customer. Yes
400 Publish events to a custom topic. Create an event subscription for each customer. Yes

401 Enable ingress, create a TCP scale rule, and apply the rule to the container app. No
403 Publish events to a partner topic. Create an event subscription for each customer. No
404 Publish events to a system topic. Create an event subscription for each customer. No

---------------------

You are a developer at your company.
You need to update the definitions for an existing Logic App.
What should you use?the Logic App Code View

You are a developer at your company.
You need to edit the workflows for an existing Logic App.
What should you use? the Logic Apps Designer

-------------------------------

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements.
You are developing a solution for a public facing API.
The API back end is hosted in an Azure App Service instance. You have implemented a RESTful service for the API back end.
You must configure back-end authentication for the API Management service instance.

Question: 43,44,45,71

CertyIQ

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 develop and deploy an Azure App Service API app to a Windows-hosted deployment slot named Development. You create additional deployment slots named Testing and Production. You enable auto swap on the Production deployment slot.
You need to ensure that scripts run and resources are available before a swap operation occurs.

43 Solution: Update the web.config file to include the applicationInitialization configuration element. Specify custom initialization actions to run the scripts.
Does the solution meet the goal?
Yes  44 Solution: Enable auto swap for the Testing slot. Deploy the app to the Testing slot.
No
45 Solution: Disable auto swap. Update the app with a method named statuscheck to run the scripts. Re-enable auto swap and deploy the app to the Production slot.
No
71 Solution: Update the app with a method named statuscheck to run the scripts. Update the app settings for the app. Set the
WEBSITE_SWAP_WARMUP_PING_PATH and WEBSITE_SWAP_WARMUP_PING_STATUSES with a path to the new method and appropriate response codes.
Yes
Question: 54,55,56,80
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 develop an HTTP triggered Azure Function app to process Azure Storage blob data. The app is triggered using an output binding on the blob.
The app continues to time out after four minutes. The app must process the blob data.
You need to ensure the app does not time out and processes the blob data.
54
Solution: Use the Durable Function async pattern to process the blob data.
Yes
55
Solution: Pass the HTTP trigger payload into an Azure Service Bus queue to be processed by a queue trigger function and return an immediate HTTP success response.
Yes
56
Solution: Configure the app to use an App Service hosting plan and enable the Always On setting.
No
80

Solution: Update the functionTimeout property of the host.json project file to 10 minutes.

No
Question: 42,46,57,70
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 develop a software as a service (SaaS) offering to manage photographs. Users upload photos to a web service which then stores the photos in Azure
Storage Blob storage. The storage account type is General-purpose V2.
When photos are uploaded, they must be processed to produce and save a mobile-friendly version of the image. The process to produce a mobile-friendly version of the image must start in less than one minute.
You need to design the process that starts the photo processing.
57
Solution: Move photo processing to an Azure Function triggered from the blob upload.
Does the solution meet the goal? Yes

 42
Solution: Trigger the photo processing from Blob storage events.
 No
46
Solution: Convert the Azure Storage account to a BlockBlobStorage storage account.
 No
70
Solution: Create an Azure Function app that uses the Consumption hosting model and that is triggered from the blob upload.
 No

Question: 98,99,100,108

CertyIQ

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 deploy an Azure Container Apps app and disable ingress on the container app.

Users report that they are unable to access the container app. You investigate and observe that the app has scaled to 0 instances.

You need to resolve the issue with the container app.

Question: 104,105,106

CertyIQ

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 Azure App Service plan named APSPlan1 set to the Basic B1 pricing tier. APSPlan1 contains an App Service web app named WebApp1.

You plan to enable schedule-based autoscaling for APSPlan1.

You need to minimize the cost of running WebApp1.

Question: 192,193,194,209

CertyIQ

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 are developing a website that will run as an Azure Web App. Users will authenticate by using their Azure Active Directory (Azure AD) credentials.
You plan to assign users one of the following permission levels for the website: admin, normal, and reader. A user's Azure AD group membership must be used to determine the permission level.
You need to configure authorization.

192
Solution: Configure the Azure Web App for the website to allow only authenticated requests and require Azure AD log on.
No
193
Solution:
✑ Create a new Azure AD application. In the application's manifest, set value of the groupMembershipClaims option to All.
✑ In the website, use the value of the groups claim from the JWT for the user to determine permissions.
Yes
194
Solution:
✑ Create a new Azure AD application. In the application's manifest, define application roles that match the required permission levels for the application.
✑ Assign the appropriate Azure AD group to each role. In the website, use the value of the roles claim from the JWT for the user to determine permissions.
Yes
209
Solution:
✑ Configure and use Integrated Windows Authentication in the website.
✑ In the website, query Microsoft Graph API to load the groups to which the user is a member.
No

Question: 206,207,210

CertyIQ

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 develop Azure solutions.
You must grant a virtual machine (VM) access to specific resource groups in Azure Resource Manager.
You need to obtain an Azure Resource Manager access token.

206
Solution: Use an X.509 certificate to authenticate the VM with Azure Resource Manager.

No
207
Solution: Use the Reader role-based access control (RBAC) role to authenticate the VM with Azure Resource Manager.
No
210
Solution: Run the Invoke-RestMethod cmdlet to make a request to the local managed identity for Azure resources endpoint.
Yes

Question: 325,326,327,329

CertyIQ

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 Azure App Service web app named WebApp1 and an Azure Functions app named Function1. WebApp1 is associated with an Application Insights instance named appinsights1.

You configure a web test and a corresponding alert for WebApp1 in appinsights1. Each alert triggers a delivery of email to your mailbox.

You need to ensure that each alert also triggers execution of Function1.
325
Solution: Configure an Azure Monitor Insights workbook.
No
326
Solution: Configure an Application Insights smart detection.
No
327
Solution: Configure an Azure Monitor action group.
Yes
Solution: Configure an Application Insights funnel.
No

Question: 126,345,346,364,373

CertyIQ

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 are developing an Azure solution to collect point-of-sale (POS) device data from 2,000 stores located throughout the world. A single device can produce 2 megabytes (MB) of data every 24 hours. Each store location has one to five devices that send data.
You must store the device data in Azure Blob storage. Device data must be correlated based on a device identifier. Additional stores are expected to open in the future.
You need to implement a solution to receive the device data.

 126

Solution: Provision an Azure Event Grid. Configure the machine identifier as the partition key and enable capture.
No

345
Solution: Provision an Azure Service Bus. Configure a topic to receive the device data by using a correlation filter.
Does the solution meet the goal?
No

346
Solution: Provision an Azure Event Grid. Configure event filtering to evaluate the device identifier.

No
Solution: Provision an Azure Event Hub. Configure the machine identifier as the partition key and enable capture.
No

373
Solution: Provision an Azure Notification Hub. Register all devices with the hub.
No

Question: 351,360,372

CertyIQ

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 are developing an Azure Service application that processes queue data when it receives a message from a mobile application. Messages may not be sent to the service consistently.
You have the following requirements:
✑ Queue size must not grow larger than 80 gigabytes (GB).
✑ Use first-in-first-out (FIFO) ordering of messages.
✑ Minimize Azure costs.
You need to implement the messaging solution.
351

 Solution: Use the .Net API to add a message to an Azure Storage Queue from the mobile application. Create an Azure Function App that uses an Azure Storage
Queue trigger.
No
360

Solution: Use the .Net API to add a message to an Azure Storage Queue from the mobile application. Create an Azure VM that is triggered from Azure Storage
Queue events.
No
372
Solution: Use the .Net API to add a message to an Azure Service Bus Queue from the mobile application. Create an Azure Function App that uses an Azure
Service Bus Queue trigger.
Yes

Question: 400,401,402,404,405

CertyIQ

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 are implementing an application by using Azure Event Grid to push near-real-time information to customers.

You have the following requirements:
•You must send events to thousands of customers that include hundreds of various event types.
•The events must be filtered by event type before processing.
•Authentication and authorization must be handled by using Microsoft Entra ID.
•The events must be published to a single endpoint.

You need to implement Azure Event Grid.
400
Solution: Publish events to an event domain. Create a custom topic for each customer.
Yes

401
Solution: Publish events to a custom topic. Create an event subscription for each customer.
Yes
402
Solution: Enable ingress, create a TCP scale rule, and apply the rule to the container app.
No
404
Solution: Publish events to a partner topic. Create an event subscription for each customer.
No
405
Solution: Publish events to a system topic. Create an event subscription for each customer.
No

Important

 https://www.youtube.com/watch?v=NWLyoCYEe0A

SP

 

ALTER PROCEDURE [dbo].[PartNumberValidation_SELECT]
  @PartNumber AS VARCHAR(80),
  @PO AS         VARCHAR(80) = NULL,
  @Badge         INT = NULL,
  @OrderType AS  VARCHAR(50) = NULL,
  @Quantity      INT = NULL,
  @Result        BIT output
AS
  BEGIN

    SET nocount ON;

    IF @OrderType IS NULL
     BEGIN

      IF EXISTS ( 1 (/* condition */))

      BEGIN
        SET @Result = 1;
      END
      else
      BEGIN
        SET @Result = 0;
      END
     END

    ELSE
    BEGIN
      IF EXISTS ( 1 )
      BEGIN
        SET @Result = 1;
      END
      else
      BEGIN
        -- Check the second condition
        IF EXISTS ( 1 )
        BEGIN
          SET @Result = 1;
        END
        else
        BEGIN
          SET @Result = 0;
        END
      END
    END
  END