- All Exams Instant Download
Which statement is an example of Data Manipulation Language (DML)?
Which statement is an example of Data Manipulation Language (DML)?A . INSERTB . DISABLEC . ALTERD . DROPView AnswerAnswer: A Explanation: Data Manipulation Language (DML) statements: DELETE INSERT UPDATE Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
Match the types of analytics that can be used to answer the business questions
DRAG DROP Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all. NOTE:...
What should the developers use?
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...
To complete the sentence select the appropriate option in the answer area
HOTSPOT To complete the sentence select the appropriate option in the answer area. View AnswerAnswer:
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
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/azure/cosmos-db/high-availability
Which statement is an example of Data Definition Language (DDL)?
Which statement is an example of Data Definition Language (DDL)?A . SELECTB . JOINC . MERGED . CREATEView AnswerAnswer: D Explanation: Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?A . Azure SQL Database HyperscaleB . Azure SQL managed instanceC . Azure SQL Database servelessD . Azure SQL Database elastic podView AnswerAnswer: B
What should you use?
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?A . Microsoft SQL Server Data Tools (SSDT)B . Microsoft SQL Server Management Studio (SSMS)C . Azure DatabricksD . Azure Data StudioView AnswerAnswer: A Explanation: Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-serverver15
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
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...
To complete the sentence, select the appropriate option in the answer area
HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture
