Microsoft Designing an Azure Data Solution

Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?

You are evaluating data storage solutions to support a new application. You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures. Which data storage solution should you recommend?

You are designing a data processing solution that will implement the lambda architecture pattern. The solution will use Spark running on HDInsight for data processing. You need to recommend a data storage technology for the solution. Which two technologies should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. 885CB989129A5F974833949052CFB2F2

A company manufactures automobile parts. The company installs IoT sensors on manufacturing machinery. You must design a solution that analyzes data from the sensors. You need to recommend a solution that meets the following requirements: Data must be analyzed in real-time. Data queries must be deployed using continuous integration. Data must be visualized by using charts and graphs. Data must be available for ETL operations in the future. The solution must support high-volume data ingestion. Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. 885CB989129A5F974833949052CFB2F2

You are designing an Azure Databricks interactive cluster. You need to ensure that the cluster meets the following requirements: Enable auto-termination Retain cluster configuration indefinitely after cluster termination. What should you recommend?

You are designing a solution for a company. The solution will use model training for objective classification. You need to design the solution. What should you recommend?

A company stores data in multiple types of cloud-based databases. You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day. What should you recommend?

You are designing an application. You plan to use Azure SQL Database to support the application. The application will extract data from the Azure SQL Database and create text documents. The text documents will be placed into a cloud-based storage solution. The text storage solution must be accessible from an SMB network share. You need to recommend a data storage solution for the text documents. Which Azure data storage type should you recommend?

You are designing an application that will have an Azure virtual machine. The virtual machine will access an Azure SQL database. The database will not be accessible from the Internet You need to recommend a solution to provide the required level of access to the database. What should you include in the recommendation?

You are designing a data store that will store organizational information for a company. The data will be used to identify the relationships between users. The data will be stored in an Azure Cosmos DB database and will contain several million objects. You need to recommend which API to use for the database. The API must minimize the complexity to query the user relationships. The solution must support fast traversals. Which API should you recommend?