Quiz
DP900 - 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (100)
1To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation,
- Aenable the hierarchical namespace.
- Bset Account kind to BlobStorage.
- Cset Performance to Premium.
- Dset Replication to Read-access-geo-redundant storage (RA-GRS).
2You can query a graph database in Azure Cosmos DB
- Aas a JSON document by using a SQL-like language.
- Bas a partitioned row store by using Cassandra Query Language (CQL).
- Cas a partitioned row store by using Language-Integrated Query (LINQ).
- Das nodes and edges by using the Gremlin language.
3You 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 type of Azure Storage should you use?- Aqueue
- Bblob
- Cfile
- Dtable
4Your 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?
- Akey/value
- Bgraph
- Ccolumnar
- Ddocument
5HOTSPOT
- AWhen ingestiong data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth. Yes.
- BWhen ingestiong data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth. No.
- CYou can use blob, table, and file storage in the same Azure Storage account. Yes.
- DYou can use blob, table, and file storage in the same Azure Storage account. No.
- EYou implement Azure Data Lake Storage by creating an Azure Storage account. Yes.
- FYou implement Azure Data Lake Storage by creating an Azure Storage account. No.
6When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a
- Agraph
- Btable
- Cpartition key
- Ddocument
7Which scenario is an example of a streaming workload?
- Asending transactions that are older than a month to an archive
- Bsending transactions daily from point of sale (POS) devices
- Csending telemetry data from edge devices
- Dsending cloud infraestructure metadata every 30 minutes
8Bacth workloads
- Aprocess data in memory, row-by-row.
- Bcollect and process data at most once a day.
- Cprocess data as new data is received in near real-time.
- Dcollect data and then process the data when a condition is met.
9HOTSPOT
- AProcessing salary payents once a month is an example of a batch workload. Yes.
- BProcessing salary payents once a month is an example of a batch workload. No.
- CA wind turbine that sends 50 sensor readings per second is an example of a streaming workload. Yes.
- DA wind turbine that sends 50 sensor readings per second is an example of a streaming workload. No.
- EA home electricity meter that send readings once a day to an energy provider is an example of a streaming workload. Yes.
- FA home electricity meter that send readings once a day to an energy provider is an example of a streaming workload. No.
10You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?- AOnline Transaction Processing (OLTP)
- Bbatch
- Cmassively parallel processing (MPP)
- Dstreaming
11You 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?- AScale down the data warehouse units (DWUs).
- BPause the pool.
- CCreate a user-defined restore point.
- DDelete the pool.
12Which Azure Data Factory component initiates the execution of a pipeline?
- Aa control flow
- Ba trigger
- Ca parameter
- Dan activity
13DRAG DROP
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.- AData movement --> Copy
- BData transformation --> Mapping data flow
- CControl --> Until
14What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.
- Adenormalized data
- Bheavy writes and moderate reads
- Clight writes and heavy reads
- Dschema on write
- Eschema on read
- Fnormalized data
15Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.
- Areport and dashboard creation
- Breport sharing and distribution
- Cdata modeling
- Ddata acquisition and preparation
16In Azure Data Factory, you can use .... to orchestrate pipeline activities that depend on the output of other pipeline activities.
- Aa control flow
- Ba dataset
- Ca linked service
- Dan integration runtime
17You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
- AOnline Transaction Processing (OLTP)
- Bbatch processing
- COnline Analytical Processig (OLAP)
- Dstream processing
18Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.- Aa report page
- Ba Microsoft PowerPoint slide
- Ca visualization from a report
- Da dataflow
- Ea text box
19HOTSPOT
- AA Microsoft Power BI dashboard is associated with a single workspace. Yes.
- BA Microsoft Power BI dashboard is associated with a single workspace. No.
- CA Microsoft Power BI dashboard can only dispay visualizations from a single dataset. Yes.
- DA Microsoft Power BI dashboard can only dispay visualizations from a single dataset. No.
- EA Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. Yes.
- FA Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. No.
20Which Azure Data Factory component provides the compute environment for activities?
- Aa linked service
- Ban integration runtime
- Ca control flow
- Da pipeline
21You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse. What should you use to query the files?
- AAzure Functions
- BMicrosoft SQL Server Integration Services (SSIS)
- CPolyBase
- DAzure Data Factory
22HOTSPOT
- AAzure Databricks is an Apache Spark-based collaborative analytics platform. Yes.
- BAzure Databricks is an Apache Spark-based collaborative analytics platform. No.
- CAzure Analysis Services is used for transactional workloads. Yes.
- DAzure Analysis Services is used for transactional workloads. No.
- EAzure Data Factory orchestrates data integration workflows. Yes.
- FAzure Data Factory orchestrates data integration workflows. No.
23HOTSPOT
- ABacth processing can output data to a file store. Yes.
- BBacth processing can output data to a file store. No.
- CBacth processing can output data to a relational database. Yes.
- DBacth processing can output data to a relational database. No.
- EBatch processing can output data to a NoSQL database. Yes.
- FBatch processing can output data to a NoSQL database. No.
24DRAG DROP
- ATreemap --> A chart of colored, nested rectangles that displays individual data points represented by the size and color of a relative rectangle.
- BKey influencer --> A chart that displays the major contributors of a selected result or value.
- CScatter --> A chart that shows the relationship beetween two numerical values.
25HOTSPOT
- APlatform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infraestructure as a service (IaaS) database offerings. Yes.
- BPlatform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infraestructure as a service (IaaS) database offerings. No.
- CPlatform as a service (PaaS) database offerings in Azure provide administrators with the ability to control and update the operating system version. Yes.
- DPlatform as a service (PaaS) database offerings in Azure provide administrators with the ability to control and update the operating system version. No.
- EAll platform as a service (PaaS) database offerins in Azure can be paused to redce costs. Yes.
- FAll platform as a service (PaaS) database offerins in Azure can be paused to redce costs. No.
26HOTSPOT
- APlatform as a service (PaaS) database offerings in Azure provice built-in high availability. Yes.
- BPlatform as a service (PaaS) database offerings in Azure provice built-in high availability. No.
- CPlatform as a service (PaaS) database offerins in Azure provide configurable scaling options. Yes.
- DPlatform as a service (PaaS) database offerins in Azure provide configurable scaling options. No.
- EPlatform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware. Yes.
- FPlatform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware. No.
27You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?
- AAzure Files
- BAzure Blob storage
- CAzure Cosmos DB
- DAzure Table storage
28HOTSPOT
- AThe Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account. Yes.
- BThe Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account. No.
- CPartition keys are used in Azure Cosmos DB to optimize queries. Yes.
- DPartition keys are used in Azure Cosmos DB to optimize queries. No.
- EItems contained in the same Azure Cosmos DB logical partition can have different partition keys. Yes.
- FItems contained in the same Azure Cosmos DB logical partition can have different partition keys. No.
29DRAG DROP
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. NOTE: Each correct match is worth one point.- AAzure Cognitive Search
- BAzure Data Catalog
- CAzure Data Factory
- DAzure Synapse Analytics
30In a data warehousing workload, data
- Afrom a single source is distributed to multiple loctions
- Bfrom multiple sources is combined in a single location
- Cis added to a queue for multiple systems to process
- Dis used to train machine learning models
31HOTSPOT
- AA pipeline is a representation of a data structure within Azure Data Factory. Yes.
- BA pipeline is a representation of a data structure within Azure Data Factory. No.
- CAzure Data Factory pipelines can execute other pipelines. Yes.
- DAzure Data Factory pipelines can execute other pipelines. No.
- EA processing step within an Azure Data Factory pipeline is an activity. Yes.
- FA processing step within an Azure Data Factory pipeline is an activity. No.
32Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)
- AAzure Time Series Insights
- BAzure HDInsight
- CAzure Databricks
- DAzure Log Analytics
33DRAG DROP
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.- AAzure Data Factory --> Output data to Parquet format
- BAzure Data Lake Storage --> Store data that is in Parquet format
- CAzure Synapse Analytics --> Persist a tabular representation of data that is stored in Parquet format
34HOTSPOT
- AAzure Synapse Analytics sclaes storage and compute independently. Yes.
- BAzure Synapse Analytics sclaes storage and compute independently. No.
- CAzure Synapse Analytics can be paused to reduce compute costs. Yes.
- DAzure Synapse Analytics can be paused to reduce compute costs. No.
- EAn Azure Synapse Analytics data warehouse has a fixed storage capacity. Yes.
- FAn Azure Synapse Analytics data warehouse has a fixed storage capacity. No.
35HOTSPOT
- AAzure Data Studio can e used to query an Azure SQL database from a device that runcs macOS. Yes.
- BAzure Data Studio can e used to query an Azure SQL database from a device that runcs macOS. No.
- CMicrosoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks. Yes.
- DMicrosoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks. No.
- EAzure Data Studio can be used to restore a database. Yes.
- FAzure Data Studio can be used to restore a database. No.
36HOTSPOT
- AAzure Databricks can consume data from Azure SQL Database. Yes.
- BAzure Databricks can consume data from Azure SQL Database. No.
- CAzure Databricks can consume data from Azure Event Hubs. Yes.
- DAzure Databricks can consume data from Azure Event Hubs. No.
- EAzure Databricks can consume data from Azure Cosmos DB. Yes.
- FAzure Databricks can consume data from Azure Cosmos DB. No.
37DRAG DROP
- AAzure Cosmos DB --> Enables the use of SQL queries against data stored in JSON documents.
- BAzure Files --> Enables users to access data by using the Server Message Block (SMB) version 3 protocol.
38Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?
- Acontrol flow
- Blinked services
- Cdatasets
- Dthe integration runtime
39Which clause should you use in a select statement to combine rows in one table with rows in another table?
- AJOIN
- BVALUES
- Cset
- DKEY
40Which three actions are used when performing diagnostic analytics?
- A• Identify data anomalies
• Collect anomaly-related data
• Discover relationships and trends that explain anomalies. - B• Identify data anomalies
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - C• Apply serf-learning loops to draw inferences from anomalies.
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - D• Identify data anomalies
• Use machine learning to find patterns in large datasets.
• Discover relationships and trends that explain anomalies.
- A• Identify data anomalies
41Which three actions are used when performing diagnostic analytics?
- A• Identify data anomalies
• Collect anomaly-related data
• Discover relationships and trends that explain anomalies. - B• Identify data anomalies
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - C• Apply serf-learning loops to draw inferences from anomalies.
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression. - D• Identify data anomalies
• Use machine learning to find patterns in large datasets.
• Discover relationships and trends that explain anomalies.
- A• Identify data anomalies
42Which storage solution supports access control lists (ACLs) at the file and folder level?
- AAzure Data Lake Storage
- BAzure Cosmos DB
- CAzure Queue storage
- DAzure Blob storage
43DRAG DROP
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 stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.- AExtract: The CRM system
- BLoad: The data warehouse
- CTransform: A standlone data analysis tool
44Which statement is an example of Data Manipulation Language (DML)?
- AREVOKE
- BDISABLE
- CCREATE
- DUPDATE
45Creating closed caption text for audio files .... analytics.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
46A visualization that illustrates a university's current student enrollment per department is an example of .... analytics.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
47An extract, load, and transform (ELT) process requires
- Aa separate transformation engine.
- Ba target data store powerfull enough to transform data.
- Cdata that is fully processed before being loaded to the target data store.
- Da data pipeline that includes a transformation engine.
48You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?- Aaz scorage share create
- Baz scorage account creace
- Caz cosmosdb creace
- Daz scorage concainer creace
49The Azure Cosmos DB .... API enables the use of SELECT statements to retrive documents from Azure Cosmos DB.
- ACore (SQL)
- BGremlin
- CMongoDB
- DTable
50You need to modify a view in a relational database by adding a new column. Which statement should you use?
- AMERGE
- BALTER
- CINSERT
- DUPDATE
51.... natively support the analysis of relationships between entities.
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
52HOTSPOT
- AExtract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems. Yes.
- BExtract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems. No.
- CExtract, load, and transform (ETL) transforms data by using a compute resource independient of the source system and destination system. Yes.
- DExtract, load, and transform (ETL) transforms data by using a compute resource independient of the source system and destination system. No.
- EExtract, load, and transform (ETL) minimizes the time it takes to copy large volumes of data to destination systems. Yes.
- FExtract, load, and transform (ETL) minimizes the time it takes to copy large volumes of data to destination systems. No.
53HOTSPOT
- APostgreSQL oon AZure VMs: Infraestructure as a service (IaaS)
- BPostgreSQL oon AZure VMs: Platform as a service (PaaS)
- CPostgreSQL oon AZure VMs: Software as a service (SaaS)
- DAzure Database for PostgreSQL: Infraestructure as a service (IaaS)
- EAzure Database for PostgreSQL: Platform as a service (PaaS)
- FAzure Database for PostgreSQL: Software as a service (SaaS)
54Relational data is stored in...
- Aa file system as unstructured data.
- Ba hierarchal folder structure.
- Ca tabular form of rows and columns.
- Dcomma-separated value (CSV) files.
55.... physically sorts the data in a table based on the values in a specified column.
- AA view
- BA clustered index
- CA stored procedure
- DA nonclustered index
56A block of code that runs in a database is called....
- Aa stored procedure.
- Ba table.
- Ca view.
- Dan index.
57Which statement is an example of Data Definition Language (DDL)?
- ASELECT
- BINSERT
- CDELETE
- DDROP
58By default, each Azure SQL database is protected by...
- Aa network security group (NSG).
- Ba server-level firewall.
- CAzure Firewall.
- DAzure Front Door.
59When provisioning an Azure Cosmos DB ...., you need to specify which type of API you will use.
- Aaccount
- Bcontainer
- Cdatabase
- Ditem
60You need to store data by using Azure Table storage. What should you create first?
- Aan Azure Cosmos DB instance
- Ba storage account
- Ca blob container
- Da table
61You need to recommend a data store service that meets the following requirements: Native SQL API access Configurable indexes. What should you recommend?
- AAzure Files
- BAzure Blob storage
- CAzure Table storage
- DAzure Cosmos DB
62HOTSPOT
- AAzure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions. Yes.
- BAzure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions. No.
- CAzure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions. Yes.
- DAzure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions. No.
- EAn Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different azure regions. Yes.
- FAn Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different azure regions. No.
- GAn Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different azure regions. Yes.
- HAn Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different azure regions. No
63To configure an Azure Storage account to support access control lists that have object-level permissions,
- Aenable the hierarchical namespace.
- Bset Account kind to BlobStorage.
- Cset Performance to Premium.
- Dset Replication to Read-access geo-redundant storage (RA-GRS).
64Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data store should you use?
- Agraph
- Bkey/value
- Cdocument
- Dcolumnar
65HOTSPOT
- AYou can copy a dashboard between Microsoft Power BI workspaces. Yes.
- BYou can copy a dashboard between Microsoft Power BI workspaces. No.
- CA Microsoft Power BI dashboard can only display visualizations from a single dataset. Yes.
- DA Microsoft Power BI dashboard can only display visualizations from a single dataset. No.
- EA Microsoft Power BI dashboard can display visualizations from Microsoft Excel workbook. Yes.
- FA Microsoft Power BI dashboard can display visualizations from Microsoft Excel workbook. No.
66What is the primary purpose of a data warehouse?
- Ato provide answers to complex queries that rely on data from multiple sources
- Bto provide transformation services between source and target data stores
- Cto provide read-only storage of relational and non-relational historical data
- Dto provide storage for transactional line-of-business (LOB) applications
67HOTSPOT
- AAzure Databricks is an Apache Spark-based collaborative analytic platform. Yes.
- BAzure Databricks is an Apache Spark-based collaborative analytic platform. No.
- CAzure Analysis Services is used for transactional workloads. Yes.
- DAzure Analysis Services is used for transactional workloads. No.
- EAzure Data Factory orchestrates data integration workflows. Yes.
- FAzure Data Factory orchestrates data integration workflows. No.
68DRAG DROP
- AWhy did sales increase last month? --> Diagnostic
- BProvide specific guidance on how to allocate current budget to buy different inventory items. --> Prescriptive
- CDetect images of the company's logo included in PDF documents --> Cognitive
69.... presents content defined by a query.
- AA heap
- BA stored procedure
- CA view
- DAn index
70Which type of database is Azure Database for PostgreSQL?
- APlatform as a service (PaaS)
- BInfrastructure as a service (laaS)
- CMicrosoft SQL Server
- Don-premises
71A .... is a chart of colored recatngles. The size of the rectangles represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nested within the main rectagle.
- Aline chart
- Bmatrix
- Cscatter
- Dtreemap
72What is a characteristic of batch processing?
- AThe data ingested during batch processing must be processed as soon as the data is received.
- BLarge datasets must be split into batches of less than 1 GB before the data can be processed.
- CThere is a noticeable time delay between ingesting data and obtaining the data processing results.
- DBatch processing can only process data that is structured.
73In a SQL statement, ...... are examples of aggregate functions.
- AFROM and WHERE
- BGROUP BY and ORDER BY
- CJOIN and MERGE
- DMAX and MIN
74HOTSPOT
- AA job that processes sales data once daily is an example of batch workload. Yes.
- BA job that processes sales data once daily is an example of batch workload. No.
- CA job that calculates a rolling average temperatire reading is an example of a streaming workload. Yes.
- DA job that calculates a rolling average temperatire reading is an example of a streaming workload. No.
- EA job that calculates average revenue per product for the last month is an example of a streaming workload. Yes.
- FA job that calculates average revenue per product for the last month is an example of a streaming workload. No.
75HOTSPOT
- AStream processing has access to the most recent data received or data within a rolling time window. Yes.
- BStream processing has access to the most recent data received or data within a rolling time window. No.
- CBatch processing must occur immediately and have latency in the order of seconds or milliseconds. Yes.
- DBatch processing must occur immediately and have latency in the order of seconds or milliseconds. No.
- EStream processing is used for simple response functions, aggregates, or calculations such as rolling averages. Yes.
- FStream processing is used for simple response functions, aggregates, or calculations such as rolling averages. No.
76You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure
Cosmos DB data sources by using Azure Synapse Analytics. What should you use?- ASynapse pipelines
- Ba Synapse SQL pool
- CSynapse Link
- DSynapse Studio
77You need to create a visualization of running sales totals per quarter as shown in the following
exhibit. What should you create in Power BI Desktop?
- Aa waterfall chart
- Ba ribbon chart
- Ca bar chart
- Da decomposition tree
78What should you use to automatically delete blobs from Azure Blob Storage?
- Asoft delete
- Barchive storage
- Cthe change feed
- Da lifecycle managament policy
79You need to store event log data that is semi-structured and received as the logs occur. What should you use?
- AAzure Table storage
- BAzure Queue storage
- CAzure Files
80What is a characteristic of a non-relational database?
- Aa fixed schema
- Bself-describing entities
- Cfull support for Transact-SQL
81When using the Azure Cosmos DB gremlin API, the container resource type is projected as a...
- Agraph
- B.
82When provisioning an Azure Cosmos DB ...., you need to specify which type of API you will use.
- Aaccount
- B.
83DRAG DROP
- AAzure SQL Database single database --> A serverless configuration.
- BAzure SQL Database elastic pool --> A database that has the highest compatibility with on-premises Microsoft SQL Server.
- CAzure SQL Managed Instance --> A low-cost, low-maintenance database.
84..... is responsible for managing the security of the data in a database.
- AA database administrator
- B.
85A block of code that runs in a database is called...
- Aa stored procedure.
- B.
86The .... clause can be used in Data Manipulation Language (DML) statement to specify the criteria that rows must match.
- AWHERE
- B.
87Which format was used?
- AXML
- Byaml
- CJSON
- DHTML
88What is a primary characteristic of a relational database?
- Adata is queried and manipulated by using a variant of the SQL language
- Ba flexible data structure
- Ca lack of dependencies between tables
- Da large amount of duplicate data
89Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
- Aisolation
- Bdurability
- Catomicity
- Dconsistency
90A relational database is appropiate for scenarios that involce a high volume of ...
- Atransactional writes
- B.
91Which property of a transactional workload guarantees that each transaction is treated as a single
unit that either succeeds completely or fails completely?- Aisolation
- Bdurability
- Cconsistency
- Datomicity
92A JSON document is an example of ...
- Asemi-structured data
- B.
93Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
- Aconsistency
- Bdurability
- Cisolation
- Datomicity
94The massively parallel processing (MPP) engine of Azure Synapse Analytics
- Adistributes processing across compute nodes.
- B.
95..... can be used as part of a lift-and.shift solution for migrating an on-premises application to the cloud with minimal changes.
- AAn instance of SQL Server on Azure Virtual Machines
- B.
96Microsoft SQL Server database tables store ...
- Arelational data.
- B.
97What is used to define a query in a stream processing jobs in Azure Stream Analytics?
- AXML
- BKQL
- CYAML
- DSQL
98Which type of Azure resource supports the serverless configuration of an Azure SQL database?
- AAzure SQL Managed Instance
- BSQL Server on Azure Virtual Machines
- Ca single database in Azure SQL Database
- Dan Azure SQL Database elastic pool
99Backing up and restoring data are the responsibilities of a ...
- Adatabase administrator
- B.
100In an infraestructure as a service (IaaS) instance of Microsoft SQL Server on Azure, you manage the .... that hosts SQL Server.
- Avirtual machine
- B.
Information
- Description
- Quiz on DP900 - 2, created by Iván Mompó Arnáez on 30/03/2026.
- Author
- Iván Mompó Arnáez
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz