The feeds will be converted into Parquet files. Store Twitter feeds in Azure Storage by using Event Hubs Capture. Maximize the throughput of ingesting Twitter feeds from Event Hubs to Azure Storage without purchasing additional throughput or capacity units. The users must be authenticated by using their own Azure AD credentials. Data must be protected by using row-level security (RLS). Customer Sentiment Analytics Requirements Contoso identifies the following requirements for customer sentiment analytics: Allow Contoso users to use PolyBase in an Azure Synapse Analytics dedicated SQL pool to query the content of the data records that host the Twitter feeds. Minimize how long it takes to remove old records. Ensure that data storage costs and performance are predictable. Implement a surrogate key to account for changes to the retail store addresses. Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible. Boundary values must belong to the partition on the right. Partitions must be designed to provide efficient loads by month. Sales Transaction Dataset Requirements Contoso identifies the following requirements for the sales transaction dataset: Partition data that contains sales transaction records. Use Azure Synapse Analytics to analyze Twitter feeds to assess customer sentiments about products. Integrate on-premises data stores with Azure Synapse Analytics by using SSIS packages. Planned Changes and Requirements Planned Changes Contoso plans to implement the following changes: Load the sales transaction dataset to Azure Synapse Analytics. Streaming Twitter Data The ecommerce department at Contoso develops an Azure logic app that captures trending Twitter feeds referencing the company's products and pushes the products to Azure Event Hubs. The product will be identified by a product ID. The promotion ID will be associated to a specific product. You plan to create a promotional table that will contain a promotion ID. Queries for retail store sales will include the retail store addresses. You plan to create a retail store table that will contain the address of each retail store. Sales transaction data that is older than three years will be removed monthly. Most queries targeting the sales transactions data will be used to identify which products were sold in retail stores and which products were sold online during different time periods. You estimate that combining all product sales transactions into a company-wide sales transactions dataset will result in a single table that contains 5 billion rows, with one row per transaction. The data is loaded into the instances by using SQL Server Integration Services (SSIS) packages. The SQL Server instances contain data from various operational systems. Existing Environment Transactional Data Contoso has three years of customer, transactional, operational, sourcing, and supplier data comprised of 10 billion records stored across multiple on-premises Microsoft SQL Server servers. Contoso has an Azure subscription associated to the Azure AD tenant. The forest it integrated with an Azure Active Directory (Azure AD) tenant named. The network contains an Active Directory forest named. The company has 2,000 retail stores across the United States and an emerging online presence. Which type of table should you use? A.hash distributed B.heap C.replicated D.round-robin Answer: C QUESTION 70 Case Study 1 - Contoso, Ltd Overview Contoso, Ltd. You need to create the table to meet the following requirements: - Provide the fastest Query time. Which authentication method should you use to access Data Lake Storage? A.shared access key authentication B.managed identity authentication C.account key authentication D.service principal authentication Answer: B QUESTION 69 You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB. The data will then be loaded to a data warehouse in Azure Synapse Analytics by using PolyBase. You plan to use Azure Data Factory to extract data from the Data Lake Storage account. QUESTION 68 You have an Azure Data Lake Storage account that has a virtual network service endpoint configured.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |