- All Exams Instant Download
Which two types of replica can you us for the storage account?
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...
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . containerB . itemC . databaseD . partitionView AnswerAnswer: AC Explanation: Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
What should you use in Microsoft Power BI?
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down. What should you use in Microsoft Power BI?A . a dashboardB . Microsoft Power AppsC . a dataflowD...
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct...
When should you implement a read-only database replica?
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?A . You need to generate reports without affecting the transactional workload.B . You need to audit the transactional application.C . You need to implement high availability in the...
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://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/ https://azure.microsoft.com/en-us/services/sql-database/#product-overview
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://www.sqlshack.com/what-is-database-normalization-in-sql-server/
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:
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
You have the following SQL query
HOTSPOT You have the following SQL query. NOTE: Each correct selection is worth one point. View AnswerAnswer:
