You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure Cosmos DB account with the Table API Do you think this is the right solution?

You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure SQL Database Do you think this is the right solution?

You are required to copy product files from the FTP server to Azure. Identify the suitable service you would use.

You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure table. Do you think this is the right solution?

You are required to copy product files from the FTP server. When copying the files, which of the following data stores serves as the destination?

Which of the following data sources would you choose for the final product data?

Can you identify from the following options which is the appropriate scheme to use if you are to design the partition distribution scheme for the Product table?

Can you identify from the following options which is the appropriate scheme to use if you are to design the partition distribution scheme for the Vendor table?

You are required provide a solution to transform data from merchant-specific formats by implementing components. Which of the following would you choose?

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Table storage. Do you think this is the right solution?

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Blob storage Do you think this is the right solution?

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Data Lake Do you think this is the right solution?

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: Before writing to Data Lake Storage Gent., you batch process files into file sizes of at least 256 MB Do you think this is the right solution?

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: Before writing to Data Lake Storage Gent, you preprocess files to make sure they are smaller than 256 MB Do you think this is the right solution?

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: You implement compaction jobs to combine smaller files into files that are 2 GB in size or larger. Do you think this is the right solution?

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use a replicated table. Do you think this is the right solution?

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use a hash-distributed table with the column that represents the postal code. Do you think this is the right solution?

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use round-robin distribution. Do you think this is the right solution?

Which of the following data store option is most suitable to general vehicle data for buses and transit trains?

You are required to make sure that rider data is structured in a way that is meets file size and processing requirements. Identify which of the following would you use?

You are required to make sure rider data meets the retention requirements. There must be minimum effort in implementation of the solution. What would be your recommendation?

You want to store initial inventory data for which you need to design a solution. Identify the resource you would use.

In order to analyze the inventory data on its arrival, you are required to design a solution. What solution would that be?

You want to store data for long-term. Which of the following resources would you use?

Which of the following would help you design a solution that might help data engineers to visualize the data?

Which of the following would you use if you want a solution that will allow business stakeholders to visualize the data?

You use Azure Stream Analytics to design a real-time processing solution. There are IoT sensors installed in the driverless vehicles and you are tasked to ingest data from those sensors. You also need to support a 200 MB reference data input to correlate related static values. Solution: For stream data input you use Azure Event Hubs and for reference input you use Azure SQL Database. Do you think this is the right solution?

You use Azure Stream Analytics to design a real-time processing solution. There are IoT sensors installed in the driverless vehicles and you are tasked to ingest data from those sensors. You also need to support a 200 MB reference data input to correlate related static values. Solution: For stream data input you use Azure Event Hubs and for reference input you use Azure Blob Storage. Do you think this is the right solution?