Which (3) open-source databases are available as platform as a service (PaaS) in Azure?

Which data service allows you to use every feature of Microsoft SQL Server in the cloud?

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

Which open-source database has a built-in support for temporal data?

Which SQL engine is optimized for IoT scenarios?

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 Azure Blob storage access tier should you use for data that will be used once per year and can have access time that takes more than an hour?

Which (2) storage solutions can be mounted in Azure Synapse Analytics and is used to process large volumes of data?

You need to replace an existing on-premise SMB shared folder with a cloud solution. Which storage option should you choose?

Which storage solution should you use to store unstructured documents, graph databases, and key/value pairs?

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

Which Azure CosmosDB API should you use for data in column-family storage structure?

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

Which strange solution allows you to aggregate data stored in JSON files for use in analytical reports without additional development effort?

Which type of data structure allows you to store data in a two-column format without requiring a complex database management system?

Which Azure data service allows you to store document, graph, and column-family databases?

Which Azure data service allows you to store images, PDF files, and static JSON files?

You have a folder that contains documents, images, and audio files.

Which type of data do you have?

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

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

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

Which (2) attributes are characteristics of a transactional data workload?

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

What are (3) properties of analytical data workloads?

Which feature of transactional data processing guarantees that concurrent processes can NOT see the data in an inconsistent state?

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

Which job role is responsible for troubleshooting index performance, provisioning access to databases, and backing up databases?

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

What should you use to create and run data ingestion pipelines?

Which native Azure service can you use to process data by running Apache Spark jobs?

Which type of data store uses Star schemas, fact tables, and dimensional tables?

Which data integration service allows you to orchestrate data flow without coding?

Which (2) services allow you to create a pipeline to process data in response to an event?

You have an Azure CosmosDB service running the SQL API. One of the operational databases has a lot of transactions. Which service allows you to perform near real-time analytics on the operational data stored in Azure CosmosDB?

Which is a characteristic of stream processing?

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?

You are processing data by using batches and streams. What should you use to ensure that transactional consistency is enforced during the processing?

Which type of visual in Microsoft Power BI should you use to compare categorized values as the proportions of a total value?

What should you create in a data model to allow users to drill up and down in a report?

Which visual in Microsoft Power BI allows you to view trends, such as changes in sales over time?

In the PowerBI service, what should you create to share a single page with the most important visuals from the reports?

Which type of data should be sent from video cameras in a native binary format?

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

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 job role is responsible for building data models and finding hidden data patterns?

What are (2) characteristics of Azure Table storage?

Which Azure CosmosDB 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 CosmosDB API should you use?

Which (2) types of files store data in columnar format?

Which (2) types of applications are used in transactional systems?

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

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

Which Azure CosmosDB API allows you to work with vertices and edges?

What should you use to process large amounts of data by using Apache Hadoop?

Which type of blob should you use to store data blocks that are added to a file frequently, but can NOT be deleted?

You have data stored in (2) tables in a database. You create a relationship between the table. Which type of data do you have?

Which service can you use to perpetually retrieve data from a Kafka queue, process the data, and write the data to Azure Data Lake?

Which (2) keys are needed to create a one-to-many relationship between two tables in a relational database?

Which (2) attributes are characteristics of an analytical data workload?

In a relational database, in which type of object should you configure a data type?

What are (2) advantages of using normalization over not using normalization in a relational database?

Which SQL operation is used to combine the content of (2) tables based on a shared column?

Which (2) 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 service is managed and serverless, avoids the use of Windows Server licenses, and allows for each workload to have its own instance of the service being used?