- All Exams Instant Download
How should you complete the query?
DRAG DROP You have a table named Sales that contains the following data. You need to query the table to return the average sales amount day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each...
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...
Which storage tier should you use?
You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?A . ArchiveB . HotC . CoolView AnswerAnswer: A
Match the tools to the appropriate descriptions
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:...
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?A . multi-master replicationB . Availability ZonesC . automatic failoverD . the strong consistency levelView AnswerAnswer: B Explanation: With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a...
A bar chart showing year-to date sales by region is an example of which type of analytics?
A bar chart showing year-to date sales by region is an example of which type of analytics?A . descriptiveB . diagnosticC . predictiveD . prescriptiveView AnswerAnswer: B
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:
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: 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
Which Azure service should you use to support the application?
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...
