web analytics

You need to recommend a disaster recovery solution for the data warehouse. What should you include in the recommendation?

You plan to use an Azure SQL data warehouse to store the customer data. You need to recommend a disaster recovery solution for the data warehouse. What should you include

You need to design a backup solution for the processed customer data. What should you include in the design?

You need to design a backup solution for the processed customer data. What should you include in the design? A. AzCopy B. AdlCopy C. Geo-Redundancy D. Geo-Replication Answer: C

Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You plan to use Azure SQL Database to support a line of business app. You need to identify sensitive data that is stored in the database and monitor access to

You need to ensure that the sensitive data remains encrypted in transit and at rest. What should you recommend?

A company stores sensitive information about customers and employees in Azure SQL Database. You need to ensure that the sensitive data remains encrypted in transit and at rest. What should

You need to recommend the appropriate Azure service. Which Azure service should you recommend?

You design data engineering solutions for a company. A project requires analytics and visualization of large set of data. The project has the following requirements: Notebook scheduling Cluster automation Power

You need to set up the database as a subscriber. What should you recommend?

You plan to migrate data to Azure SQL Database. The database must remain synchronized with updates to Microsoft Azure and SQL Server. You need to set up the database as

What should you recommend?

You are designing a real-time stream solution based on Azure Functions. The solution will process data uploaded to Azure Blob Storage. The solution requirements are as follows: New blobs must

Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have a Windows-based solution that analyzes scientific data. You are designing a cloud-based solution that performs real-time analysis of the data. You need to design the logical flow for

What should you recommend?

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected from Azure Event Hub. The data must be transmitted to Power BI for

Which type of activity should you recommend?

You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in general-purpose standard Azure storage. You need to ensure that the

You need to manually scale the Azure SQL Database instance to account for the increase in data write operations. Which scaling method should you recommend?

A company has an application that uses Azure SQL Database as the data store. The application experiences a large increase in activity during the last month of each year. You

You need to design the staging tables. What type of tables should you recommend?

You are designing an Azure SQL Data Warehouse. You plan to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are

You need to optimize storage for CONT_SQL3. What should you recommend?

You need to optimize storage for CONT_SQL3. What should you recommend? A. AlwaysOn B. Transactional processing C. General D. Data warehousing Answer: B

You need to design the runtime environment for the Real Time Response system. What should you recommend?

You need to design the runtime environment for the Real Time Response system. What should you recommend? A. General Purpose nodes without the Enterprise Security package B. Memory Optimized Nodes

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. 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.

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?

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

You need to design the solution. 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. an Azure

What should you recommend?

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

Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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

Which two technologies should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

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

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 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.

Proposed Solution: Separate data into shards by using horizontal partitioning. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Proposed Solution: Separate data into customer regions by using horizontal partitioning. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Proposed Solution: Separate data into customer regions by using vertical partitioning. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Proposed Solution: Ensure that files stored are smaller than 250MB. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Proposed Solution: Implement compaction jobs to combine small files into larger files. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Proposed Solution: Ensure that files stored are larger than 250MB. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

You need to recommend the appropriate storage and processing solution? What should you recommend?

You need to recommend the appropriate storage and processing solution? What should you recommend? A. Enable auto-shrink on the database. B. Flush the blob cache using Windows PowerShell. C. Enable

You need to recommend an Azure SQL Database service tier. What should you recommend?

You need to recommend an Azure SQL Database service tier. What should you recommend? A. Business Critical B. General Purpose C. Premium D. Standard E. Basic Answer: C

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3. Which type of disk should you recommend?

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3. Which type of disk should you recommend? A. Standard SSD Managed Disk B. Premium SSD

You need to design the solution for analyzing customer data. What should you recommend?

You need to design the solution for analyzing customer data. What should you recommend? A. Azure Databricks B. Azure Data Lake Storage C. Azure SQL Data Warehouse D. Azure Cognitive

You need to recommend a solution for storing the image tagging data. What should you recommend?

You need to recommend a solution for storing the image tagging data. What should you recommend? A. Azure File Storage B. Azure Cosmos DB C. Azure Blob Storage D. Azure

You need to recommend an Azure SQL Database pricing tier for Planning Assistance. Which pricing tier should you recommend?

You need to recommend an Azure SQL Database pricing tier for Planning Assistance. Which pricing tier should you recommend? A. Business critical Azure SQL Database single database B. General purpose

You need to design a sharding strategy for the Planning Assistance database. What should you recommend?

You need to design a sharding strategy for the Planning Assistance database. What should you recommend? A. a list mapping shard map on the binary representation of the License Plate

You need to design the vehicle images storage solution. What should you recommend?

You need to design the vehicle images storage solution. What should you recommend? A. Azure Media Services B. Azure Premium Storage account C. Azure Redis Cache D. Azure Cosmos DB