What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

schema defined when reading unstructured data from a database

heavy writes and moderate reads

schema defined when reading unstructured data from a database

heavy writes and moderate reads

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQLServer instances, while providing automated updates, backups, and maintenance tasks?

SQL Server on Azure Virtual Machines

A data engineer is responsible for which task?

Implement policies, tools. and processes for backup and recovery plans.

Design and build analytical models.

Design and implement data stores for analytical workloads.

Explore data to identify trends.

Implement policies, tools. and processes for backup and recovery plans.

What is a difference between structured data and semi-structured data?

Structured data has a fixed schema and semi-structured data has a flexible schema.

Only Structured data supports entities.

Structured data has a flexible schema and semi-structured data has a fixed schema.

Only Structured data supports attributes.

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

an Azure SQL Database elastic pool

Which Azure Cosmos DB API should you use for a graph database?

Azure Cosmos DB for Apache Gremlin

Azure Cosmos DB for Apache Cassandra

In a fully denormalized database, how is data read and written for a single entity?

Data is read from multiple tables and written to a single table.

Data is read from a single table and written to a single table.

Data is read from multiple tables and written to a single table.

Data is read from a single table and written to multiple tables.

Data is read from multiple tables and written to multiple tables.

You have a banking application that transfers money in to and out of accounts.Of which type of solution is this is an example?

online transaction processing (OLTP)

extract transform, and load (ETL)

online analytical processing (OLAP)

online transaction processing (OLTP)

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Data Manipulation Language (DML)

Which service is optimized for loT scenarios that involve streaming time series data?

SQL Server on Azure Virtual Machines

What is the responsibility of a database administrator?

managing data integration processes

applying data cleaning routines

managing data integration processes

Microsoft DP-900 Practice Test 7 - Free Online Exam Questions 241-280

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Microsoft DP-900 Practice Test 7

Question

Microsoft DP-900 Practice Tests

Practice Tests