No Result
View All Result
Quesions Library
Contribute
No Result
View All Result
No Result
View All Result

 


Questions › Category: DP-201
Filter:AllUnanswered
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?
Admin asked 9 months ago • 
20 views0 answers0 votes
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? Each correct answer presents a complete solution. NOTE: Each correct…
Admin asked 9 months ago • 
20 views0 answers0 votes
Your company is an online retailer that can have more than 100 million orders during a 24-hour period, 95 percent of which are placed between 16:30 and 17:00. All the orders are in US dollars. The current product line contains the following three item categories: ✑ Games with 15,123 items ✑ Books with 35,312 items ✑ Pens with 6,234 items You are designing an Azure Cosmos DB data solution for…
Admin asked 9 months ago • 
17 views0 answers0 votes
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…
Admin asked 9 months ago • 
47 views0 answers0 votes
HOTSPOT – You are designing a new application that uses Azure Cosmos DB. The application will support a variety of data patterns including log records and social media relationships. You need to recommend which Cosmos DB API to use for each data pattern. The solution must minimize resource utilization. Which API should you recommend for each data pattern? To answer, select the appropriate options in the answer area. NOTE: Each…
Admin asked 9 months ago • 
21 views0 answers0 votes
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….
Admin asked 9 months ago • 
21 views0 answers0 votes
DRAG DROP – You need to design a data architecture to bring together all your data at any scale and provide insights into all your users through the use of analytical dashboards, operational reports, and advanced analytics. How should you complete the architecture? To answer, drag the appropriate Azure services to the correct locations in the architecture. Each service may be used once, more than once, or not at all….
Admin asked 9 months ago • 
16 views0 answers0 votes
You are designing a log storage solution that will use Azure Blob storage containers. CSV log files will be generated by a multi-tenant application. The log files will be generated for each customer at five-minute intervals. There will be more than 5,000 customers. Typically, the customers will query data generated on the day the data was created. You need to recommend a naming convention for the virtual directories and files….
Admin asked 9 months ago • 
28 views0 answers0 votes
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?
Admin asked 9 months ago • 
75 views0 answers0 votes
You work for a finance company. You need to design a business network analysis solution that meets the following requirements: ✑ Analyzes the flow of transactions between the Azure environments of the company's various partner organizations ✑ Supports Gremlin (graph) queries What should you include in the solution?
Admin asked 9 months ago • 
113 views0 answers0 votes
HOTSPOT – You are designing a solution that will use Azure Table storage. The solution will log records in the following entity. You are evaluating which partition key to use based on the following two scenarios: ✑ Scenario1: Minimize hotspots under heavy write workloads. ✑ Scenario2: Ensure that date lookups are as efficient as possible for read workloads. Which partition key should you use for each scenario? To answer, select…
Admin asked 9 months ago • 
24 views0 answers0 votes
You are designing an Azure Cosmos DB database that will contain news articles. The articles will have the following properties: Category, Created Datetime, Publish Datetime, Author, Headline, Body Text, and Publish Status. Multiple articles will be published in each category daily, but no two stories in a category will be published simultaneously. Headlines may be updated over time. Publish Status will have the following values: draft, published, updated, and removed….
Admin asked 9 months ago • 
14 views0 answers0 votes
You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting. Which storage solution should you use?
Admin asked 9 months ago • 
15 views0 answers0 votes
You need to design a solution to support the storage of datasets. The solution must meet the following requirements: ✑ Send email alerts when new datasets are added. ✑ Control access to collections of datasets by using Azure Active Directory groups. Support the storage of Microsoft Excel, Comma Separated Values (CSV), and zip files. What should you include in the solution?
Admin asked 9 months ago • 
93 views0 answers0 votes
HOTSPOT – You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit. All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB. Which type of table should you use for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct…
Admin asked 9 months ago • 
23 views0 answers0 votes
You are designing a product catalog for a customer. The product data will be stored in Azure Cosmos DB. The product properties will be different for each product and additional properties will be added to products as needed. Which Cosmos DB API should you use to provision the database?
Admin asked 9 months ago • 
15 views0 answers0 votes
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders. You need to configure data access so that users see only the files in their respective department folder. Solution: From…
Admin asked 9 months ago • 
17 views0 answers0 votes
You are designing a serving layer for data. The design must meet the following requirements: ✑ Authenticate users by using Azure Active Directory (Azure AD). ✑ Serve as a hot path for data. ✑ Support query scale out. ✑ Support SQL queries. What should you include in the design?
Admin asked 9 months ago • 
71 views0 answers0 votes
HOTSPOT – You are evaluating the use of an Azure Cosmos DB account for a new database. The proposed account will be configured as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:
Admin asked 9 months ago • 
19 views0 answers0 votes
You are designing a storage solution for streaming data that is processed by Azure Databricks. The solution must meet the following requirements: ✑ The data schema must be fluid. ✑ The source data must have a high throughput. ✑ The data must be available in multiple Azure regions as quickly as possible. What should you include in the solution to meet the requirements?
Admin asked 9 months ago • 
89 views0 answers0 votes
« Previous1…891011Next »

Other exams

No Result
View All Result

Welcome Back!

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Fill the forms below to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In