DP-900 V2

You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. (Choose three.)A . You must be assigned the...

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?A . a tableB . an indexC . scalar functionD . a viewView AnswerAnswer: D...

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?A . native support for cross-database queries and transactionsB . built-in high availabilityC . system-Initiated automatic backupsD . support for encryption at restView AnswerAnswer: A Explanation: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?A . supports partitioningB . provides resiliency if art Azure region fadsC . provides a higher storage capacityD . supports a multi-master modelView AnswerAnswer: D Explanation: Multi-master support for Azure Cosmos DB is now...

DRAG DROP Match the tools to the appropriate descriptions. To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. View AnswerAnswer:...

You need to create an Azure Storage account. Data in the account must replica outside the Azure region automatically. Which two types of replica can you us for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pint.A . read-access geo-redundant storage...

Which setting can only be configured during the creation of an Azure Cosmos DB account?A . geo-redundancyB . multi-region writesC . production or non-reduction account typeD . APIView AnswerAnswer: D Explanation: You must create a separate account for each API. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer:

When you create an Azure SQL database, which account can always connect to the database ?A . the Azure Active director/ (Azure AO) account that created the databaseB . the Azure Active Directly Azure AD) administrator accountC . the sa accountD . the server admin login account of the logical...

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. Which type of data store should you recommend?A . documentB . key/valueC...