DP-900 2 ATOS

Which Azure service is commonly used for hosting SQL Server databases in the cloud?

• Azure Cosmos DB

• Azure SQL Database

• Azure Synapse Analytics

• Azure Blob Storage

What is a benefit of using Azure SQL Managed Instance?

• Only supports basic SQL functions

• Allows full SQL Server compatibility

• Requires local server installation

• Primarily for NoSQL databases

Which deployment option offers maximum control over the SQL Server environment in Azure?

• Azure Cosmos DB

• Azure SQL Managed Instance

• SQL Server on Azure Virtual Machines

• Azure SQL Database

Which of the following is a key benefit of using Azure SQL Database?

• Limited scalability

• High availability and automated backups

• Dependency on on-premises infrastructure

• Increased operational complexity

Which Azure service is suitable for non-relational databases?

• • Azure Cosmos DB

• Azure SQL Database

• Azure SQL Managed Instance

• SQL Server on Azure VM

Which is true for SQL Server on Azure Virtual Machines?

• Best for lightweight applications

• Fully managed by Azure

• Ideal for users needing control over the OS and SQL Server

• Requires no SQL Server licensing

What type of database is Azure Database for PostgreSQL categorized as?

• Relational

• NoSQL

• Time-Series

• Graph

Which Azure service allows for the provisioning of a database with minimal administration overhead?

• SQL Server on Azure VM

• Azure SQL Database

• Azure Database for MySQL

• Azure SQL Managed Instance

What type of data consistency does Azure Cosmos DB guarantee with its "Strong" consistency model?

• Updates are immediately visible to all clients.

• Updates are immediately visible to all clients.

• Data is guaranteed to be consistent with eventual consistency.

• Data is only consistent at certain intervals.

What does ETL stand for in the context of data processing?

• Extract, Transform, Link

• Extract, Transfer, Load

• Evaluate, Transform, Load

• Extract, Transform, Load