Match the types of data stores to the appropriate scenarios

DRAG DROP Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all. NOTE: Each correct...

April 18, 2022 No Comments READ MORE +

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?A . documentB . columnarC . graphD . time seriesView AnswerAnswer: A

April 18, 2022 No Comments READ MORE +

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:

April 18, 2022 No Comments READ MORE +

Match the types of workloads the appropriate scenario

DRAG DROP Match the types of workloads the appropriate scenario. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all. NOTE: Each correct match is worth one...

April 18, 2022 No Comments READ MORE +

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

April 17, 2022 No Comments READ MORE +

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

April 17, 2022 No Comments READ MORE +

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?A . control flowB . linked servicesC . datasetsD . the integration runtimeView AnswerAnswer: A

April 17, 2022 No Comments READ MORE +

What should you use?

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?A . Microsoft SQL Server Management Studio (SSMS)B . Azure Data StudioC . Azure CLID . Azure...

April 16, 2022 No Comments READ MORE +

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)A . denormalized dataB . heavy writes and moderate readsC . light writes and heavy readsD . schema on writeE . schema on...

April 16, 2022 No Comments READ MORE +

What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.

What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.A . Represent trends and patterns over time.B . Communicate the significance of data.C . implement machine learning to predict future values.D . Consistently implement business logic across reportsView...

April 16, 2022 No Comments READ MORE +