DP-900 exam

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

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?A . Azure Cosmos DBB . Azure Synapse AnalyticsC . Azure HDInsightD . Azure SQL DatabaseView AnswerAnswer: D Explanation: Azure SQL...

You have an Azure SQL database that you access directly from the internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure What is a possible cause of the issue?A . a...

DRAG DROP Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match...

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Disadvantages of non-relational databases include: Data Consistency ― non-relational databases do not perform ACID transactions. Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include...

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 have a SQL query that combines customer data and order dat a. 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:...

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Generally speaking, data analytics comes in four types (Figure 1): Descriptive, to answer the question: What’s happening? Diagnostic, to answer the question: Why’s happening? Predictive, to answer the question: What will happen? Prescriptive, to...

HOTSPOT For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . complete control over backup and restore processesB . access to the latest featuresC ....