This page was exported from Best Free Exam Guide [ http://free.exams4sures.com ] Export date:Sat Mar 15 7:56:07 2025 / +0000 GMT ___________________________________________________ Title: [Q28-Q45] Get instant access to DP-420 Practice Tests 2022 Free Updated Today! --------------------------------------------------- Get instant access to DP-420 Practice Tests 2022 Free Updated Today! Welcome to download the newest PassLeader DP-420 PDF dumps ( 52 Q&As) NEW QUESTION 28You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions.You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput.Which sink setting should you configure?  Throughput  Write throughput budget  Batch size  Collection action Batch size: An integer that represents how many objects are being written to Cosmos DB collection in each batch. Usually, starting with the default batch size is sufficient. To further tune this value, note:Cosmos DB limits single request’s size to 2MB. The formula is “Request Size = Single Document Size * Batch Size”. If you hit error saying “Request size is too large”, reduce the batch size value.The larger the batch size, the better throughput the service can achieve, while make sure you allocate enough RUs to empower your workload.Incorrect Answers:A: Throughput: Set an optional value for the number of RUs you’d like to apply to your CosmosDB collection for each execution of this data flow. Minimum is 400.B: Write throughput budget: An integer that represents the RUs you want to allocate for this Data Flow write operation, out of the total throughput allocated to the collection.D: Collection action: Determines whether to recreate the destination collection prior to writing.None: No action will be done to the collection.Recreate: The collection will get dropped and recreatedNEW QUESTION 29You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.The following is a sample of a document in container1.The orderId property is used as the partition key.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. NEW QUESTION 30You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region writes. The account contains a database that has two containers named container1 and container2.The following is a sample of a document in container1:{“customerId”: 1234,“firstName”: “John”,“lastName”: “Smith”,“policyYear”: 2021}The following is a sample of a document in container2:{“gpsId”: 1234,“latitude”: 38.8951,“longitude”: -77.0364}You need to configure conflict resolution to meet the following requirements:For container1 you must resolve conflicts by using the highest value for policyYear.For container2 you must resolve conflicts by accepting the distance closest to latitude: 40.730610 and longitude: -73.935242.Administrative effort must be minimized to implement the solution.What should you configure for each container? To answer, drag the appropriate configurations to the correct containers. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/conflict-resolution-policieshttps://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-conflictsNEW QUESTION 31You have the following query.SELECT * FROM cWHERE c.sensor = “TEMP1”AND c.value < 22AND c.timestamp >= 1619146031231You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.What should you recommend?  a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)  a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)  a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)  a composite index for (sensor ASC, value ASC, timestamp ASC) If a query has a filter with two or more properties, adding a composite index will improve performance.Consider the following query:SELECT * FROM c WHERE c.name = “Tim” and c.age > 18In the absence of a composite index on (name ASC, and age ASC), we will utilize a range index for this query. We can improve the efficiency of this query by creating a composite index for name and age.Queries with multiple equality filters and a maximum of one range filter (such as >,<, <=, >=, !=) will utilize the composite index.NEW QUESTION 32You have an Azure Cosmos DB Core (SQL) API account.You run the following query against a container in the account.SELECTIS_NUMBER(“1234”) AS A,IS_NUMBER(1234) AS B,IS_NUMBER({prop: 1234}) AS CWhat is the output of the query?  [{“A”: false, “B”: true, “C”: false}]  [{“A”: true, “B”: false, “C”: true}]  [{“A”: true, “B”: true, “C”: false}]  [{“A”: true, “B”: true, “C”: true}] IS_NUMBER returns a Boolean value indicating if the type of the specified expression is a number.“1234” is a string, not a number.NEW QUESTION 33Note: 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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.Solution: You create an Azure Data Factory pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.Does this meet the goal?  Yes  No NEW QUESTION 34You have an Azure Cosmos DB Core (SQL) API account named account1 that has the disableKeyBasedMetadataWriteAccess property enabled.You are developing an app named App1 that will be used by a user named DevUser1 to create containers in account1. DevUser1 has a non-privileged user account in the Azure Active Directory (Azure AD) tenant.You need to ensure that DevUser1 can use App1 to create containers in account1.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/secure-access-to-datahttps://docs.microsoft.com/en-us/rest/api/resources/NEW QUESTION 35You plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a single database. The accounts will be configured as shown in the following table.How should you provision the containers within each account to minimize costs? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/serverlesshttps://docs.microsoft.com/en-us/azure/cosmos-db/provision-throughput-autoscale#use-cases-of-autoscaleNEW QUESTION 36You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours.You need to implement a solution that supports point-in-time restore.What should you do first?  Enable Continuous Backup for the account.  Configure the Backup & Restore settings for the account.  Create a new account that has a periodic backup policy.  Configure the Point In Time Restore settings for the account. NEW QUESTION 37You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.You discover that every query consumes request units (RUs) instead of using the cache.You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.You verify that the dedicated gateway cluster is provisioned and used in the connection string.You need to ensure that App1 uses the Azure Cosmos DB integrated cache.What should you configure?  the indexing policy of the Azure Cosmos DB container  the consistency level of the requests from App1  the connectivity mode of the App1 CosmosClient  the default consistency level of the Azure Cosmos DB account Because the integrated cache is specific to your Azure Cosmos DB account and requires significant CPU and memory, it requires a dedicated gateway node. Connect to Azure Cosmos DB using gateway mode.NEW QUESTION 38Note: 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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.Solution: You create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.Does this meet the goal?  Yes  No The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.The following diagram represents the data flow and components involved in the solution:NEW QUESTION 39Note: 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 a container named container1 in an Azure Cosmos DB Core (SQL) API account.You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.Does this meet the goal?  Yes  No Instead create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.The following diagram represents the data flow and components involved in the solution:NEW QUESTION 40You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.You discover that function1 runs, but not on every upsert.You need to ensure that function1 processes each upsert within one second of the upsert.Which property should you change in the Function.json file of function1?  checkpointInterval  leaseCollectionsThroughput  maxItemsPerInvocation  feedPollDelay With an upsert operation we can either insert or update an existing record at the same time.FeedPollDelay: The time (in milliseconds) for the delay between polling a partition for new changes on the feed, after all current changes are drained. Default is 5,000 milliseconds, or 5 seconds.Incorrect Answers:A: checkpointInterval: When set, it defines, in milliseconds, the interval between lease checkpoints. Default is always after each Function call.C: maxItemsPerInvocation: When set, this property sets the maximum number of items received per Function call. If operations in the monitored collection are performed through stored procedures, transaction scope is preserved when reading items from the change feed. As a result, the number of items received could be higher than the specified value so that the items changed by the same transaction are returned as part of one atomic batch.NEW QUESTION 41You have an Azure Cosmos DB Core (SQL) API account.You configure the diagnostic settings to send all log information to a Log Analytics workspace.You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified.You write the following query.AzureDiagnostics| where Category == “ControlPlaneRequests”What should you include in the query?  | where OperationName startswith “AccountUpdateStart”  | where OperationName startswith “SqlContainersDelete”  | where OperationName startswith “MongoCollectionsThroughputUpdate”  | where OperationName startswith “SqlContainersThroughputUpdate” The following are the operation names in diagnostic logs for different operations:RegionAddStart, RegionAddCompleteRegionRemoveStart, RegionRemoveCompleteAccountDeleteStart, AccountDeleteCompleteRegionFailoverStart, RegionFailoverCompleteAccountCreateStart, AccountCreateComplete*AccountUpdateStart*, AccountUpdateCompleteVirtualNetworkDeleteStart, VirtualNetworkDeleteCompleteDiagnosticLogUpdateStart, DiagnosticLogUpdateCompleteNEW QUESTION 42Note: 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 Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.Solution: You configure an application to use the change feed processor to read the change feed and you configure the application to trigger the function.Does this meet the goal?  Yes  No Instead configure an Azure Monitor alert to trigger the function.You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the Azure portal.NEW QUESTION 43You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stores IoT dat a. The database contains two containers named readings and devices.Documents in readings have the following structure.iddeviceidtimestampowneridmeasures (array)– type– value– metricidDocuments in devices have the following structure.iddeviceidowner– ownerid– emailaddress– namebrandmodelFor each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. NEW QUESTION 44You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned throughput capacity mode.The storage1 account contains the databases shown in the following table.The databases contain the containers shown in the following table.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/cosmos-db/plan-manage-costshttps://azure.microsoft.com/en-us/pricing/details/cosmos-db/NEW QUESTION 45Note: 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 Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.Solution: You configure the function to have an Azure CosmosDB trigger.Does this meet the goal?  Yes  No Instead configure an Azure Monitor alert to trigger the function.You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the Azure portal. Loading … Sep-2022 Latest Exams4sures DP-420 Exam Dumps with PDF and Exam Engine: https://www.exams4sures.com/Microsoft/DP-420-practice-exam-dumps.html --------------------------------------------------- Images: https://free.exams4sures.com/wp-content/plugins/watu/loading.gif https://free.exams4sures.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-09-20 15:45:55 Post date GMT: 2022-09-20 15:45:55 Post modified date: 2022-09-20 15:45:55 Post modified date GMT: 2022-09-20 15:45:55