Which service is built on Apache Spark and is compatible with other cloud providers?

What should you create first for an integration process that copies data from Microsoft Excel files to Parquet files by using Azure Data Factory?

What is a characteristic of batch processing?

Which two services can be used as a source for stream processing? Each correct answer presents a complete solution.

In a stream processing architecture, what can you use to persist the processed results as files?

Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?

Which type of data structure should you use to optimize create, read, update, and delete (CRUD) operations for data saved in a multi-column tabular format?

You have data stored in two tables in a database.

You create a relationship between the tables.

Which type of data do you have?

Which is the best type of database to use for an organizational chart?

Which type of database should you use to store sequential data in the fastest way possible?

You design an application that needs to store data based on the following requirements:

• Store historical data from multiple data sources.

• Load data on a scheduled basis.

• Use a denormalized star or snowflake schema.

Which type of database should you use?

Which service allows you to store data as a graph database?

Which type of database can be used for semi-structured data that will be processed by an Apache Spark pool in Azure Synapse Analytics?

Which two types of file store data in columnar format?

Which Azure Cosmos DB API allows you to implement a non-relational database and model nodes that have relationships between them?

Which two attributes are characteristics of an analytical data workload?

Which type of data workload is optimized for updates and relies on relationships between entities to correlate data?

Which job role is responsible for designing database solutions, creating databases, and developing stored procedures?

Which job role is responsible for managing the security of the data in a database, implementing backup and recovery plans, and monitoring the performance of database solutions?

Which job role is responsible for managing data privacy, monitoring data stores, and monitoring data pipelines?

In a relational database, on which type of objects should you configure a datatype?

Which SQL clause can be used to copy all the rows from one table to a new table?

....................... is a process to reduce duplicate data in a database and ensure data integrity.

What should you create to improve the performance of a query accessing a table that contains millions of rows?

You have a complex query that selects data from multiple tables.

Which three database objects should allow you to reuse the query definition?

Which two DML statements are used to modify the existing data in a table?

In a relational database, what can you use to create a virtual table from the results of a SELECT statement?

Which data service provides a fully managed database with close to 100 percent feature parity with Microsoft SQL Server?

Which data service allows you to create a single database that can scale up and down without downtime?

Which data service allows you to migrate an entire Microsoft SQL server to the cloud without requiring that you manage the infrastructure after the migration?

Which open-source database is a hybrid relational-object database?

Which type of Azure Storage is the least expensive option that allows you to store and edit image files?

Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?

Which type of Azure Storage is used to store large amounts of data that must be processed by services such as Azure Databricks, Azure Synapse Analytics, and Azure HDInsight?

Which type of Azure Storage is used to store key/value pairs grouped in partitions?

Which two storage solutions can be mounted in Azure Synapse Analytics and used to process large volumes of data?

Which Azure Cosmos DB API should you use for data in a graph structure?

Which Azure Cosmos DB API should you use for data in the BSON format?

Which Azure Cosmos DB API should you use for data in key/value tables?

You need to process many JSON files every minute, while keeping the data from the files accessible by using native queries.

Which Azure Cosmos DB API should you use?

Which Azure Cosmos DB API is queried by using a syntax based on SQL?