Complete list of current Q & A>> Download Designing Azure Data Solution. Associate (DP-201) – Quiz 1 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You plan to store 100 GB of data used by a line-of-business (LOB) app. You need to recommend a data storage solution for the data. The solution must meet the following requirements: ✑ Minimize storage costs. ✑ Natively support relational queries. ✑ Provide a recovery time objective (RTO) of less than one minute. What should you include in the recommendation? A. Azure Cosmos DB B. Azure SQL Database C. Azure Synapse Analytics D. Azure Blob storage 2 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You are designing a big data storage solution. The solution must meet the following requirements: ✑ Provide unlimited account sizes. ✑ Support a hierarchical file system. ✑ Be optimized for parallel analytics workloads. Which storage solution should you use? A. Azure Data Lake Storage Gen2 B. Azure Blob storage C. Apache HBase in Azure HDInsight D. Azure Cosmos DB 3 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You are designing an Azure Cosmos DB database that will support vertices and edges. Which Cosmos DB API should you include in the design? A. SQL B. Cassandra C. Gremlin D. Table 4 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders. Which storage solution should you recommend? A. Azure Data Lake Storage Gen2 B. Azure Cosmos DB C. Azure SQL Database D. Azure Blob storage 5 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the MongoDB API. During testing, you discover that the migration takes longer than expected. You need to recommend a solution that will reduce the amount of time it takes to migrate the data. What are two possible recommendations to achieve this goal? A. Increase the Request Units (RUs). B. Turn off indexing. C. Add a write region. D. Create unique indexes. E. Create compound indexes. 6 / 15 Category: Designing Azure Data Solution. Associate (DP-201) You need to recommend a storage solution to store flat files and columnar optimized files. The solution must meet the following requirements: ✑ Store standardized data that data scientists will explore in a curated folder. ✑ Ensure that applications cannot access the curated folder. ✑ Store staged data for import to applications in a raw folder. ✑ Provide data scientists with access to specific folders in the raw folder and all the content the curated folder. Which storage solution should you recommend? A. Azure Synapse Analytics B. Azure Blob storage C. Azure Data Lake Storage Gen2 D. Azure SQL Database 7 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. MongoDB B. Table C. Gremlin D. Cassandra 8 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Deploy an On-premises data gateway. B. Add a virtual network to the Azure SQL server that hosts the database. C. Add an application gateway to the virtual network that contains the Azure virtual machine. D. Add a virtual network gateway to the virtual network that contains the Azure virtual machine. 9 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Queue B. Files C. Blob D. Table 10 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. SQL Server Migration Assistant B. SQL Data Sync C. Azure Data Factory D. Azure Database Migration Service E. Data Migration Assistant 11 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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 Cognitive Services application B. a Spark Streaming job C. interactive Spark queries D. Power BI models E. a Spark application that uses Spark MLib. 12 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Start the cluster after it is terminated. B. Pin the cluster C. Clone the cluster after it is terminated. D. Terminate the cluster manually at process completion. 13 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Use Azure Analysis Services to query the data. Output query results to Power BI. B. Configure an Azure Event Hub to capture data to Azure Data Lake Storage. C. Develop an Azure Stream Analytics application that queries the data and outputs to Power BI. Use Azure Data Factory to deploy the Azure Stream Analytics application. D. Develop an application that sends the IoT data to an Azure Event Hub. E. Develop an Azure Stream Analytics application that queries the data and outputs to Power BI. Use Azure Pipelines to deploy the Azure Stream Analytics application. F. Develop an application that sends the IoT data to an Azure Data Lake Storage container. 14 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Azure Cosmos DB B. Azure Service Bus C. Azure Storage Queue D. Apache Cassandra E. Kafka HDInsight 15 / 15 Category: Designing Azure Data Solution. Associate (DP-201) 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? A. Blob Storage B. Azure Cosmos DB C. Azure Data Lake Store D. HDInsight Your score is 0% Restart quiz Send feedback