1. A relational database is appropiate for scenarios that involve a high volume of: changes to relationships between entities geographically distributed writes transactional writes writes that have varying data structures.
2. An extract, load and transform (ELT) process requires: a data pipeline that includes a transformation engine a separate transformation engine a target data store powerful enough to transform data data that is fully processed before being loaded to the target data store.
3. ¿A bar chart showing year-to date sales by region is an example of which type of analytics? Descriptive Diagnostic Predictive Prescriptive.
4. A visualization that show a univertisty's current student enrollment versus the maximum capacity is an example of _______ analytics Cognitive Descriptive Predictive Prescriptive.
5. Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content. Extract: Load: Transform:.
6. Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter? Predictive Prescription Descriptive Diagnostic.
7. Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the
right. Each workload type may be used once, more than once or not at all.
NOTE: Each correct match is worth one point. Batch Streaming Micro-batch.
8. For each of the following statements, select yes if the statement is true, Otherwise, select No. Batch processing can output data a file store. Batch processing can output data to relational database. Batch processing can output data to NoSQL database.
9. Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
Cognitive Descriptive Diagnostic Predictive Prescriptive.
10. To complete the sentence, select the appropriate option in the answer area.
Relational data is stored in: ___________________ a file system as unstructured data. a hierarchal folder structure. a tabular form of rows and colums. comma-separated value (CSV) files.
11. What are two uses of data visualization? Each correct answer present a complete solution. Represent trends and patterns over time. Communicate the significance of data. Implement machine learning to predict future values. Consistently implement business logic across reports.
12. To answer, drag the appropriate workload type from the column on the left to its scenario on the
right. Each workload type may be used once, more than once, or not at all. Batch Streaming.
13. To complete the sentence, select the appropriate option in the answer area.
A Microsoft Power BI _______ enabled users to create highly formatted, fixed-layout documents for archiving. dashboard interactive report paginated report subscription.
14. Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
Azure Analysis Services Azure Cosmos DB Azure Data Factory Azure Synapse Analytics Azure Table Storage.
15. You have an e-commerce application that reads and writes data to an Azure SQL database. Which
type of processing does the application use? stream processing batch processing Online Analytical Processing (OLAP) Online Transaction Processing (OLTP).
16. What are two characteristics of real-time data processing? Each correct answer present a complete solution. Data is processed as it is created. Low latency is expected High latency acceptable Data is processed periodically.
17. Which two Azure services can be used to provision Spark clusters? Each correct answer presents a
complete solution. Azure Databricks Azure Log Analytics Azure Time Series Insights Azure HDinsight.
18. You need to develop a solution to provide data to executives. The solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI? a dashboard Microsoft Power Apps a dataflow a report.
19. What should you use to build a Microsoft Power BI paginated report? Power BI report Builder Power BI Desktop Charticulator the Power BI service.
20. For each of the following statements, select Yes if the statement is true. Otherwise select No. A pipeline is a representation of a data structure within Azure Data Factory. Azure Data Factory pipelines can execute other pipelines. A processing step within an Azure Data Factory pipeline is an activity.
21. Match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
Dataset Linked service Mapping data flow Pipeline.
22. Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use? stream processing Online Transaction Processing (OLTP) batch processing Online Analytical Processing (OLAP).
23. Match the Azure services to appropriate requirements. Azure Data Factory Azure Data Lake Storage Azure SQL Database Azure Synapse Analytics.
24. The massively parallel processing (MPP) engine of Azure Synapse Analytics: distributes processing across compute notes distributes processing across control nodes redirects client connections across compute notes redirects client connections across control nodes.
25. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)? Azure Queue Storage Azure Data Lake Storage Azure Table Storage Azure Files.
26. You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica? You need to generate reports without affecting the transactional workload. You need to audit the transactional application. You need to implement high availability in the event of a regional outage. You need to improve the recovery point objective (RPO).
27. For each of the following statements, select Yes if the statement is true, Otherwise, select No. Azure Synapse Analytics scales storage and compute independently. Azure Synapse Analytics can be paused to reduce compute costs. An Azure Synapse Analytics data warehose has fixed storage capacity.
28. For each of the following statements, select yes if he statement is true, Otherwise select No. Azure Databricks can consume data from Azure SQL Database. Azure Databricks can consume data from Azure Event Hubs. Azure Data Bricks can consume data from Azure Cosmos DB.
29. A key/value data store is optimized for enforcing constraints simple lookups table joins transactions.
30. You have an application that runs on Windows and requires across to a mapped drive.
Which Azure service should you use? Azure Cosmos DB Azure Table storage Azure Files Azure Blob Storage.
31. You can query a graph database in Azure Cosmos DB as a JSON document by using a SQL-like language. as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.
32. Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use? Key/value Graph Document columnar.
33. You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend? document key/value object columnar.
34. You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution. read-access geo-redundant storage (RA_GRS) zone-redundant storage (ZRS) geo-redundant storage (GRS) locally-redundant storage (LRS).
35. For each of the following statements. select Yes if the statement is true. Otherwise, select No. The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos. Partition keys are used in Azure Cosmos DB to optimize queries. Items contained in the same Azure Cosmos DB logical partition can have different partition keys.
36. When can you use an Azure Resource Manager template? To automate the creation of an interdependent group of Azure resources in a repeatable way. To automate the creation of an interdependent and develop can deploy from the Azure portal. To provision Azure subscriptions and apply policies for multi-tenant deployments. To set complex permissions automatically on existing objects in an Azure subscription.
37. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure
region? multi-master replication Availability Zones automatic failover the strong consistency level.
38. At which level in Azure Cosmos DB can you configure multiple write regions and read regions? database partition collection account.
39. Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use? key/value document graph columnar.
40. At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. container item database partition.
41. Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. Azure Storage account File system File share.
42. To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation enable the hierarchical namespace. set Account kind to BlobStorage. set Performance to Premium. set Replication to Read-access geo-redundant storage (RA-GRS).
43. Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use? relational columnar graph time series.
44. What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage? supports partitioning provides resiliency if art Azure region fads provides a higher storage capacity supports a multi-master model.
45. Which setting can only be configured during the creation of an Azure Cosmos DB account? geo-redundancy multi-region writes production or non-reduction account type API.
|
