- All Exams Instant Download
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?A . INSERTB . MERGEC . UPDATED . CREATEView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15
Where does data processing occur for each stage of the ELT process?
DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each...
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:
Which two settings can you configure at the container level?
You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)A . the throughputB . the read regionC . the partition...
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://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Azure DatabricksB . Azure Log AnalyticsC . Azure Time Series InsightsD . Azure HDinsightView AnswerAnswer: A, D Explanation: Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
Which Azure service should you use?
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?A . Azure HDInsightB . Azure SQL DatabaseC . Azure Cosmos DBD . SQL Server on Azure virtual machinesView AnswerAnswer: B Explanation: Reference: https://azure.microsoft.com/en-us/services/sql-database/#features
Which setting can only be configured during the creation of an Azure Cosmos DB account?
Which setting can only be configured during the creation of an Azure Cosmos DB account?A . geo-redundancyB . multi-region writesC . production or non-reduction account typeD . APIView AnswerAnswer: D Explanation: You must create a separate account for each API. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account
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/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.A . Data is processed as it is created.B . Low latency is expectedC . High latency acceptableD . Data is processed periodicallyView AnswerAnswer: AB Explanation: Real time...
