DP-900

A. graph

Complete the sentence. When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a _____________. A. graph B. table C. partition key D. document

B. diagnostic

A bar chart showing year-to date sales by region is an example of which type of analytics? A. descriptive B. diagnostic C. predictive D. prescriptive

A. Azure Data Studio

A set of developers have computers that run Windows 10 and Ubuntu Desktop. They need to connect and query an Azure SQL database from their computer. The developers require code assistance features such as IntelliSense. Which of the following can be used for this requirement? A. Azure Data Studio B. Microsoft SQL Server Management Studio (SSMS) C. Azure Data Explorer

D. account

At which level in Azure Cosmos DB can you configure multiple write regions and read regions? A. database B. partition C. collection D. account

A. database C. Container

At which two levels can you set the throughput for an Azure Cosmos DB account? (Choose 2) A. database B. Item C. Container D. SQL partition

A. cognitive

Complete the sentence. Transcribing audio files is an example of ___________ analytics. A. cognitive B. descriptive C. predictive D. prescriptive

C. the database to protect data at rest

Complete the sentence. Transparent Data Encryption (TDE) encrypts _____________. A. a column to protect data at rest and in transit B. queries and their results in order to protect data in transit C. the database to protect data at rest D. the server to protect data at rest

D. collect data and then process the data when a condition is met

Complete the sentence Batch workloads __________________. A. process data in memory, row-by-row B. collect and process data at most once a day C. process data as new data is received in near real-time D. collect data and then process the data when a condition is met

B. what occurred in the past

Complete the sentence Descriptive analytics tells you _________________. A. what is most likely to occur in the future. B. what occurred in the past C. which actions you can perform to affect outcomes D. why something occurred in the past

B. simple lookups

Complete the sentence. A key/value data store is optimized for _______________. A. enforcing constraints B. simple lookups C. table joins D. transactions

C. transactional writes

Complete the sentence. A relational database is appropriate for scenarios that involve a high volume of ______________. A. changes to relationships between entities B. geographically distributed writes C. transactional writes D. writes that have varying data structures

D. strong consistency guarantees are required

Complete the sentence. A relational database must be used when ____________. A. a dynamic schema is required B. data will be stored as key/value pairs C. storing large images and videos D. strong consistency guarantees are required

B. descriptive

Complete the sentence. A visualization that shows a university's current student enrollment versus the maximum capacity is an example of _______________ analytics. A. cognitive B. descriptive C. predictive D. prescriptive

C. data that is fully processed before being loaded to the target data store

Complete the sentence. An extract, transform, and load (ETL) process requires ___________________. A. a matching schema in the data source and the data target B. a target data store powerful enough to transform data C. data that is fully processed before being loaded to the target data store D. that the data target be a relational database

B. a server-level firewall

Complete the sentence. By default, each Azure SQL database is protected by _____________ A. a network security group (NSG) B. a server-level firewall C. Azure Firewall D. Azure Front Door

A. a control flow

Complete the sentence. In Azure Data Factory, you can use _________________ to orchestrate pipeline activities that depend on the output of other pipeline activities A. a control flow B. a dataset C. a linked service D. an integration runtime

B. from multiple sources is combined in a single location

Complete the sentence. In a data warehouse workload, data _____________. A. from a single source is distributed to multiple locations B. from multiple sources is combined in a single location C. is added to a queue for multiple systems to process D. is used to train machine learning models

C. latency is expected

Complete the sentence. In batch processing, ______________________. A. data is always inserted one row at a time B. data is processed in real-time C. latency is expected D. processing can only execute serially

A. distributes processing across compute nodes

Complete the sentence. The massively parallel processing (MPP) engine of Azure Synapse Analytics ______________________. A. distributes processing across compute nodes B. distributes processing across control nodes C. redirects client connections across compute nodes D. redirects client connections across control nodes

A. enable the hierarchical namespace

Complete the sentence. To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation, _______________. A. enable the hierarchical namespace B. set Account kind to BlobStorage C. set Performance to Premium D. set Replication to Read-access geo-redundant storage (RA-GRS)

A. as a JSON document by using a SQL-like language

Complete the sentence. You can query a graph database in Azure Cosmos DB ____________. A. as a JSON document by using a SQL-like language B. as a partitioned row store by using Cassandra Query Language (CQL) C. as a partitioned row store by using Language-Integrated Query (LINQ) D. as nodes and edges by using the Gremlin language

A. Azure Cosmos DB B. Azure Files

Match the datastore services to the appropriate descriptions. Each service may be used once, more than once, or not at all. A. Enables the use of SQL queries against data stored in JSON documents B. Enables users to access data by using the Server Message Block (SMB) version 3 protocol Services: Azure Blob storage Azure Cosmos DB Azure Files Azure Table storage

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Batch processing can output data to a file store B. Batch processing can output data to a relational database C. Batch processing can output data to a NoSQL database

A. No B. Yes C. No

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates. B. If you have a platform as a service (PaaS) database in Azure, backups are performed automatically. C. If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine.

C. Azure SQL Database serverless

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods? A. Azure SQL Database Hyperscale B. Azure SQL managed instance C. Azure SQL Database serverless D. Azure SQL Database elastic pod

A. No B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. A pipeline is a representation of a data structure within Azure Data Factory B. Azure Data Factory pipelines can execute other pipelines C. A processing step within an Azure Data Pipeline is an activity

A. Yes B. No C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure Data Studio can be used to query an Azure SQL database from a device that runs on macOS B. Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks C. Azure Data Studio can be used to restore a database

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure Databricks can consume data from Azure SQL Database B. Azure Databricks can consume data from Azure Event Hubs C. Azure Databricks can consume data from Azure Cosmos DB

A. Yes B. No C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure Databricks is an Apache Spark-based collaborative analytics platform B. Azure Analysis Services is used for transactional workloads C. Azure Data Factory orchestrates data integration workflows

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure SQL Database includes a fully managed backup service B. Azure SQL Database has built-in high availability C. Azure SQL Database can use Azure Advanced Threat Protection (ATP)

A. Yes B. Yes C. No

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure Synapse Analytics scales storage and compute independently B. Azure Synapse Analytics can be paused to reduce compute costs C. An Azure Synapse Analytics data warehouse has a fixed storage capacity

A. Yes B. No C. Yes D. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Azure Table storage supports multiple read replicas B. Azure Table storage supports multiple write regions C. The Azure Cosmos DB Table API supports multiple read replicas D. The Azure Cosmos DB Table API supports multiple write regions

A. Yes B. No C. No

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings. B. Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control and update the operating system version. C. All platform as a service (PaaS) database offerings in Azure can be paused to reduce costs.

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Platform as a service (Paas) database offerings in Azure provide built-in high availability B. Platform as a service (Paas) database offerings in Azure provide configurable scaling options C. Platform as a service (Paas) database offerings in Azure reduce the administrative overhead for managing hardware

A. Yes B. Yes C. No

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. Processing salary payments once a month is an example of a batch workload B. A wind turbine that sends 50 sensor readings per second is an example of streaming workload C. A home electricity meter that sends readings once a day to an energy provider is an example of a streaming workload

A. No B. Yes C. No

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account B. Partition keys are used in Azure Cosmos DB to optimize queries C. Items contained in the same Azure Cosmos DB logical partition can have different partition keys

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth B. You can use blob, table, and file storage in the same Azure Storage account C. You implement Azure Data Lake Storage by creating an Azure Storage account

A. Yes B. Yes C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. You can use Azure Data Studio to query a Microsoft SQL Server big data cluster B. You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse C. You can use MySQL Workbench to query Azure Database for MariaDB databases

A. No B. No C. Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. A. You must apply patches to Azure SQL databases regularly B. You need a Microsoft 365 subscription to create an Azure SQL Database C. You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases

A. descriptive

I have a car showroom and I am thinking to open a new branch of my showroom. I want to find out where I should open my new showroom based on sales data. Which analytics will tell me that? A. descriptive B. diagnostic C. predictive D. prescriptive

A. Azure Data Factory B. Azure Data Lake Storage C. Azure Synapse Analytics

Match the Azure services to the appropriate requirements. Each service may be used once, more than once, or not at all. A. Output data to Parquet format B. Store data that is in Parquet format C. Persist a tabular representation of data that is stored in Parquet format Services: Azure Data Factory Azure Data Lake Storage Azure SQL Database Azure Synapse Analytics

A. Gremlin API B. MongoDB API C. Table API

Match the Azure Cosmos DB APIs to the appropriate data structures. Each API may be used once, more than once, or not at all. A. Graph data B. JSON documents C. Key/ value data APIs: Cassandra API Gremlin API MongoDB API Table API

A. Dataset B. Linked service C. Pipeline

Match the Azure Data Factory components to the appropriate descriptions. Each component may be used once, more than once, or not at all. A. A representation of data structures within data stores B. The information used to connect to external resources C. A logical grouping of activities that performs a unit of work and can be scheduled components: Dataset Linked service Mapping data flow Pipeline

A. Azure Data Factory B. Azure Synapse Analytics

Match the Azure services to the appropriate locations in the architecture. Each service may be used once, more than once, or not at all. INPUT: Logs, structured data, and other data structures ---> A. Ingest -----> Store- Azure Data Lake Storage -----> B. Preprocess & Model -----> OLAP- Azure Analysis Services -----> Reporting- Microsoft Power Bi Services: Azure Cognitive Search Azure Data Catalog Azure Data Factory Azure Synapse Analytics

A. Azure Data Factory B. Azure Synapse Analytics

Match the Azure services to the appropriate locations in the architecture. Each service may be used once, more than once, or not at all. SQL Server, SAP HANA, Azure Cosmos DB ---> going into A. Extract Transform Load (ETL) B. Data Warehouse Azure Services: Azure Analysis Services Azure Data Factory Azure Table storage Azure Cosmos DB Azure Synapse Analytics

A. Firewall B. Authentication C. Encryption

Match the security components to the appropriate scenarios. Each component may be used once, more than once, or not at all. A. Prevent access to an Azure SQL database from another network B. Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database. C. Ensure that sensitive data never appears as plain text in an Azure SQL database Components: Authentication Firewall Encryption

A. Microsoft SQL Server Management Studio (SSMS) B. Microsoft Visual Studio Code C. Azure Data Studio D. Microsoft SQL Server Data Tools (SSDT)

Match the tools to the appropriate descriptions. Each tool may be used once, more than once, or not at all. A. A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks. B. A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL. C. A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files. D. A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports. Tools: Azure Data Studio Microsoft SQL Server Data Tools (SSDT) Microsoft SQL Server Management Studio (SSMS) Microsoft Visual Studio Code

A. Data movement B. Data transformation C. Control

Match the types of activities to the appropriate Azure Data Factory activities. Each activity type may be used once, more than once, or not at all. A. Copy B. Mapping data flow C. Until Activity Types: Control Data movement Data transformation

A. Azure Storage account B. Container

Match the types of activities to the appropriate Azure Data Factory activities. Each activity type may be used once, more than once, or not at all. Levels: Azure Resource Group A. _________ B. _________ Folders Files Terms: Azure Storage account File share Container

A. Diagnostic B. Prescriptive C. Descriptive

Match the types of analytics that can be used to answer the business question. Each analytics type may be used once, more than once, or not at all. A. Why did sales increase last month? B. How do I allocate my budge to buy different inventory items? C. Which people are mentioned in a company's business documents? Analytics Types: Cognitive Diagnostic Descriptive Predictive Prescriptive

A. Key / value B. Object C. Graph

Match the types of data stores to the appropriate scenarios. Each data store type may be used once, more than once, or not at all. A. Application users and their default language B. Medical image and their associated metadata C. Employee data that shows the relationships between employees Data Store Types: Graph Object Key / value

A. Image files B. Relationships between employees C. Key/ value pairs

Match the types of data to the appropriate Azure data services. Each data type may be used once, more than once, or not at all. A. Azure Blob storage B. Azure Cosmos DB Gremlin API C. Azure Table storage Data Types: Image files Key/ value pairs Relationships between employees

A. Treemap B. Key Influencer C. Scatter

Match the types of visualizations to the appropriate descriptions. Each visualization type may be used once, more than once, or not at all. A. A chart of colored, nested rectangles that displays individual data points represented by the size and color of a relative rectangle B. A chart that displays the major contributors of a selected result or value C. A chart that shows the relationship between two numerical values Visualizations: Key Influencer Scatter Treemap

A. Batch B. Batch C. Streaming

Match the types of workloads to the appropriate scenarios. Each workload type may be used once, more than once, or not at all. A. Analyzing web traffic from the past year B. Classifying images that were uploaded last month C. Tracking how many people are currently using a website Workloads: Batch Streaming

A. Batch B. Streaming C. Batch

Match the types of workloads to the appropriate scenarios. Each workload type may be used once, more than once, or not at all. A. Data for a product catalog will be loaded every 12 hours to a data warehouse B. Data for online purchases will be loaded to a data warehouse as the purchases occur C. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions workloads: Batch Streaming

B. heavy writes and moderate reads D. schema on write F. normalized data

What are three characteristics of an Online Transactional Processing (OLTP) workload? (Choose 3) A. denormalized data B. heavy writes and moderate reads C. light writes and heavy reads D. schema on write E. schema on read F. normalized data

A. access to the latest features D. reduced administrative effort for managing the server infrastructure

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? A. access to the latest features B. complete control over backup and restore processes C. in-database machine learning services D. reduced administrative effort for managing the server infrastructure

B. Low Latency is expected D. Data is processed as it is created

What are two characteristics of real-time data processing? (Choose 2) A. Data is processed periodically B. Low Latency is expected C. High Latency is acceptable D. Data is processed as it is created

A. Represent trends and patterns over time C. Communicate the significance of data

What are two uses of data visualization? (choose 2) A. Represent trends and patterns over time B. Implement machine learning to predict future values C. Communicate the significance of data D. Consistently implement business logic across reports

B. native support for cross-database queries and transactions

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? A. built-in high availability B. native support for cross-database queries and transactions C. system-initiated automatic backups D. support for encryption at rest

D. supports a multi-master model

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table Storage? A. provides resiliency if an Azure region fails B. supports partitioning C. provides a higher storage capacity D. supports a multi-master model

A. to automate the creation of an interdependent group of Azure resources in a repeatable way

When can you use an Azure Resource Manager template? A. to automate the creation of an interdependent group of Azure resources in a repeatable way B. to apply Azure policies for multi-tenant deployments C. to provision Azure subscriptions D. to control which services and feature administrators and developers can deploy from the Azure portal

B. Availability Zones

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region? A. multi-master replication B. Availability Zones C. the strong consistency level D. automatic failover

C. the server admin login account of the logical server

When you create an Azure SQL database, which account can always connect to the database? A. the Azure Active Directory (Azure AD) account that created the database B. the sa account C. the server admin login account of the logical server D. the Azure Active Directory (Azure AD) administrator account

B. a trigger

Which Azure Data Factory component initiates the execution of a pipeline? A. a control flow B. a trigger C. a parameter D. an activity

B. an integration runtime

Which Azure Data Factory component provides the compute environment for activities? A. a linked service B. an integration runtime C. a control flow D. a pipeline

A. sqlcmd

Which command-line tool can you use to query Azure SQL databases? A. sqlcmd B. bcp C. azdata D. Azure CLI

C. Storage Explorer

Which is not a tool to access DB? A. Query Editor B. Data Studio C. Storage Explorer D. VS Code

C. a target data store powerful enough to transform the data

Which of the following is required for an extract, load, and transform (ELT) process? A. a data pipeline that includes a transformation engine B. a separate a transformation engine C. a target data store powerful enough to transform the data D. data that is fully processed before being loaded to the target data store

C. sending telemetry data from edge devices

Which scenario is an example of a streaming workload? A. sending transactions that are older than a month to an archive B. sending transactions daily from point of sale (POS) devices C. sending telemetry data from edge devices D. sending cloud infrastructure metadata every 30 minutes

B. Azure Data Lake Storage

Which storage solution supports role-based access control (RBAC) at the file and folder level? A. Azure Disk Storage B. Azure Data Lake Storage C. Azure Blob storage D. Azure Queue storage

B. Azure HDInsight C. Azure Databricks

Which two Azure services can be used to provision Apache Spark clusters? (choose 2) A. Azure Time Series Insights B. Azure HDInsight C. Azure Databricks D. Azure Log Analytics

A. document

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores all the data for an entity in the same document? A. document B. columnar C. graph D. time series

C. Azure SQL Database

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transactional Processing (OLTP). Which Azure service should you use to support the application? A. Azure Cosmos DB B. Azure HDInsight C. Azure SQL Database D. SQL Synapse Analytics

B. Azure Data Studio

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use? A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell

B. Pause the pool

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact. What should you do on the SQL pool? A. Scale down the data warehouse units (DWUs) B. Pause the pool C. Create a user-defined restore point D. Delete the pool

D. Online Analytical Processing (OLAP)

You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use? A. Online Transactional Processing (OLTP) B. batch processing C. stream processing D. Online Analytical Processing (OLAP)

A. You need to generate reports without affecting the transactional workload

You have a transactional application that stores data in an Azure SQL managed instance. In which of the following circumstances would you need to implement a read-only database replica? A. You need to generate reports without affecting the transactional workload B. You need to audit the transactional application C. You need to implement high availability in the event of a regional outage. D. You need to improve the recovery point objective (RPO)

A. the throughput C. the partition key

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? (choose 2) A. the throughput B. the read region C. the partition key D. the API

D. a database-level firewall

You have an Azure SQL database that you access directly from the internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue? A. role-based access control (RBAC) B. Dynamic Host Configuration Protocol (DHCP) C. Domain Name Service (DNS) D. a database-level firewall

A. Azure Files

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use? A. Azure Files B. Azure Blob Storage C. Azure Cosmos DB D. Azure Table storage

D. Online Transactional Processing (OLTP)

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use? A. Online Analytical Processing (OLAP) B. batch processing C. stream processing D. Online Transactional Processing (OLTP)

1. C. a root object 2. B. a nested object 3. A. a nested array

You have the following JSON document: "customer" : { "first name" : "Ben", "last name" : "Smith", "address" : { "line 1" : "161 Azure Ln", "line 2" : "Palo Alto", "ZIP code" : "54762" }, "social media" : [ { "service" : "twitter", "handle" : "@bensmith" }, { "service" : "linkedin", "handle" : "bensmith" } ], "phone number": [ { "type" : "mobile", "number" : "555-555-555" } ] } Fill in blanks of following statements: 1. Customer is _________ A. a nested array B. a nested object C. a root object 2. Address is _________ A. a nested array B. a nested object C. a root object 3. Social media is ________ A. a nested array B. a nested object C. a root object

C. file

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which of the following service within Azure storage account could you use for this purpose? A. queue B. blob C. file D. table

B. read-access geo-redundant storage (RA-GRS) D. geo-redundant storage (GRS)

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? (choose 2) A. zone-redundant storage (ZRS) B. read-access geo-redundant storage (RA-GRS) C. locally-redundant storage (LRS) D. geo-redundant storage (GRS)

A. Microsoft SQL Server Data Tools (SSDT)

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use? A. Microsoft SQL Server Data Tools (SSDT) B. Microsoft SQL Server Management Studio (SSMS) C. Azure Databricks D. Azure Data Studio

B. Azure Active Directory (Azure AD) authentication

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use? A. service principle authentication B. Azure Active Directory (Azure AD) authentication C. SQL authentication D. certificate authentication

D. streaming

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario? A. Online Transaction Processing (OLTP) B. batch C. massively parallel processing (MPP) D. streaming

B. You must have SELECT access to the Products table C. You must have a user in the database E. Your IP address must be allowed to connect to the database

You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution (Choose 3) A. You must be assigned the Reader role for the resource group that contains the database B. You must have SELECT access to the Products table C. You must have a user in the database D. You must be assigned the Contributor role for the resource group that contains the database E. Your IP address must be allowed to connect to the database

C. Object

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, 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? A. Key/ value B. Columnar C. Object D. Document

A. Archive

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use? A. Archive B. Hot C. Cool

C. Online Analytical Processing (OLAP)

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? A. stream processing B. batch processing C. Online Analytical Processing (OLAP) D. Online Transactional Processing (OLTP)

B. time series

Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use? A. relational B. time series C. graph D. columnar

D. columnar

Your company is designing a data store that will contain student data. The data has the following format: (StudentNum & StudentInfo are 2 separate columns) StudentNumber: (1) 7634634 (2) 7634634 (3) 7634636 (4) 7634637 StudentInformation: (1) First name: Ben (1) Last: Smith (1) Preferred Name: Benjamin (2) First Name: Dominik (2) Last Name: Paiha (2) Email Address: [email protected] (2) MCP ID: 931817 (3) First Name: Reshma (3) Last Name: Patel (3) Phone number: 514-555-1101 (4) First Name: Yun-Feng (4) Last Name: Peng What type of data store should you use? A. graph B. key/value C. object D. columnar

C. columnar

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data? A. key/value B. graph C. columnar D. document

B. key/ value

Your company is 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? A. columnar B. key/ value C. document D. graph

A. graph

Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. What type of data store should you use? A. graph B. key/value C. document D. columnar

B. Azure SQL Database

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use? A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure virtual machines

A. The CRM system B. The data warehouse C. An in-memory data integration tool

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? Each location may be used once, more than once, or not at all. A. Extract: B. Load: C. Transform: Locations: An in-memory data integration tool The CRM system The data warehouse

D. Prescriptive

Your company recently reported sales from the third quarter. (graph of 3 quarter earnings, but an goal estimate for 4th quarter) Which type of analysis is shown for the fourth quarter? A. Descriptive B. Diagnostic C. Predictive D. Prescriptive