DP-900

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

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use?A . Azure Data StudioB . sq1cmdC . Microsoft...

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

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Text Description automatically generated with medium confidence

DRAG DROP Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE:...

HOTSPOT You have the following SQL query. NOTE: Each correct selection is worth one point. View AnswerAnswer:

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: Box 1: Yes Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually...

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Graphical user interface, text, application Description automatically generated

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Box 1: simple lookups A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely),...

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