You can configure Cosmos DB IP Firewall to enable access for a specific IP address, an address range, or a combination of addresses ranges.

You can configure Azure Cosmos DB IP Firewall to configure access from services that do not have a static IP address such as Azure Functions.

Your company application requires you to store user profile data, like shipping address and user preferences. Each user can have multiple addresses and preference fields. You need to use the best non-relational data store for this type of data. Which type of non-relational data should you use?

You are migrating an application to Azure. This application uses shared network folder as a data store. You need to move the shared network folder to Azure storage. Which type of Azure storage should you use?

You should use batch workload to build a monthly payroll for your company.

You should use a streaming workload to monitor temperature sensors on a production line.

You should use a streaming workload to measure the weekly gas consumption in a neighborhood.

Batch processing workloads are best suited to collecting a group of data with a scheduled time interval or when a certain amount of data has arrived.

You should use batch workload to monitor temperature sensors on a production line.

Streaming processing workloads are best suited to handling continuous data used by time-critical operations.

Determine whether each statement applies to batch data, stream data, or both as they are implemented in Azure.

Data with similar content can be processed from multiple sources.

Determine whether each statement applies to batch data, stream data, or both as they are implemented in Azure.

Data can be subjected to detailed analysis to generate visuals and reports.

Determine whether each statement applies to batch data, stream data, or both as they are implemented in Azure.

Data is used for transaction processing requiring immediate, consistent postings.

Determine whether each statement applies to batch data, stream data, or both as they are implemented in Azure.

Data processed can include large quantities of data.

Azure Data Factory is a cloud-based Extract-Transform-Load (ETL) service. It lets you create data-driven workflows for orchestrating data movement and data transformation.

Data-driven workflows are also known as pipelines.

Azure Data Factory and Azure Synapse Analytics have three groupings of activities: data movement activities, data transformation activities and control activities.

A Data Factory or Synapse Workspace can have one or more pipelines.

A pipeline is a logical grouping of activities that together perform a task.

Azure Synapse Analytics and Apache Hive on HDInsight are data warehousing solutions that support massively parallel processing (MPP).

Azure SQL Database uses symmetric multiprocessing (SMP).

You can use Azure SQL Database for data warehouses in which the dataset is within a few TB.

Online Analytical Processing (OLAP) systems are designed to perform complex analysis and provide business intelligence.

You can use Azure Analysis Services to support OLAP.

Cosmos DB Table API support multi-region writes.

Cosmos DB Table API and Azure Table Storage supports multi-region reads replicas.

IaaS database solutions reduce the administrative overhead for managing security patches and updates.

PaaS solutions provide built-in high availability.

PaaS database solutions give you full control to configure the underlying operational system.

You work as a Database Administrator. You need to identify characteristics of relational Azure data services.

Which two options should you use for Platform-as-a-Service (PaaS) relational data services?

You plan to reduce costs to store non-structured data in Azure Blob Storage. The data needs to be accessible occasionally to generate reports that must be available as soon as possible. Which tier should you use?

Which of the following is NOT a DDL statement?

You design a query that joins customer, inventory, and order data. The query includes columns with calculated values. You need to query to be readily available to users. You want to maintain the normalization of your database. What should you create?

You need to implement a non-relational store data for a new application. The application needs to store data in JSON format with flexible schema. All the entity should be stored together in the same structure. Which type of non-relational data store should you use?

A column-family data store consists of row identifiers and a group of information stored in a column.

You need to support a reporting system that performs data mining in a large amount of data. Which type of workload should you use?

You can use stream processing workloads to handle a continuous data used by time-critical operations.

You can use batch processing workloads to collect a group of data with a scheduled time interval or when a certain amount of data has arrived that is not time-sensitive.

The databases that a business uses to store all its transactions and records are called Online Transaction Processing (OLTP) databases.

OLAP databases are optimized for heavy read, low write workloads.

It is used to encrypt data at rest, including databases, transaction logs, and backups without requiring changes to the applications

It is used to help protect sensitive data from access by limiting access to data at rest, in movement, and in use to client applications that have appropriate access to keys.

It is used to encrypt data in motion between the databases server and clients using certificate-based encryption.

It is used to limit exposure to sensitive data to non-privileged users by designating how much of the sensitive data can be revealed.

In managing an Azure Cosmo DB Account ...

You can configure autoscale throughput at the database and container level.

In managing an Azure Cosmo DB Account ...

You can configure the default consistency level at the account level only.

In managing an Azure Cosmo DB Account ...

You can configure Cosmo DB API at the account level only.

You can only configure only one Cosmo DB API for each account and it cannot be changed after the creation.

You can use Azure Data Studio to connect with PostgreSQL databases by installing PostgreSQL extension for Azure Studio.

You can use SQL Server Management Studio (SSMS) to connect and query Synapse SQL in Azure Synapse Analytics through SQL pool resources or SQL on-demand.

You can use MySQL Workbench to connect with Azure Database for MariaDB.

MariaDB is a database created from a fork of MySQL database.

Azure Databricks is an analytical platform based on Apache Spark.

Azure Databricks can process batch processing workloads only.

Azure Databricks provides an interactive workspace for exploration and data visualization.

You can perform real-time data processing and event streaming from Azure Event Hubs with Azure Databricks.

You can run notebooks in R, Python, Scala, or SQL, and interact with the data very quickly in Azure Databricks.

The contributor role provides the ability to create and manage all types of Azure resources but without permission to grant access to other users.

Both General Purpose version 2 and File storage accounts support Azure File Share, but you can only create a premium Azure file share in a File storage account.

You can create a standard file share account only in a General Purpose version 2 account.

You can configure a premium Azure file share for locally redundant storage (LRS), zone redundant storage (ZRS) or geo-redundant storage(GRS).

You can use premium Azure File Share to replace or supplement traditional on-premises file shares.

You need to provide a temporary read-write access to your Azure Cosmos DB database to other users who do not have access to Azure portal or subscription. What should you use?

It lets you manipulate and manage entities such as stored procedures including Cosmos DB, Blob storage, and Queue Storage.

You work as an Azure Data Administrator.

You provisioned the Azure SQL Database, which of the following port should you open for outbound traffic to connect to the data service from your corporate network?

You work as an Azure Data Administrator.

You provisioned the Azure Database for MySQL, which of the following port should you open for outbound traffic to connect to the data service from your corporate network?

You work as an Azure Data Administrator.

You provisioned the Azure Database for PostgreSQL, which of the following port should you open for outbound traffic to connect to the data service from your corporate network?

In which two situations should you use data warehouse solution?

It is a constraint used to enforce data integrity in relational database by indicating which column (or combination of columns) uniquely identifies each row in a table.

It is a constraint used to create relationships between tables by referencing a primary key from other tables.

It is a table that does not have a clustered index implemented.

Your company is writing an application that will receive real-time events from multiple sources which may vary in schema. The application should be able to write the data to a data store quickly as possible. It should also be able to lookup the value from the data store by using a unique key. What is the best type of data store you can use?

You should use Azure Managed Instance if your database uses features like SQL Server Agent and Database Mail.

It refers to a collection of ready-made visuals pre-arranged on reports and dashboards.

Report based on a single dataset generated using Power BI Desktop as a collection of one or more pages of visuals.

A unique combination of data pulled from various sources and used to create a visualization.

A rectangular box that contains a single visual for use with a report or dashboard that support user interaction.

The extract, load, transform (ETL) process performs transformation in the target data store.

Azure SQL Database allows you to choose the SQL Server engine.

Which two statements identify features that are supported by Azure Cosmos DB Table API but not Azure Table Storage?

An Azure Management Resource provides the best way to provision a set of Azure services to multiple environments and save the configuration for future deployments.

You can use Power BI Report Builder to author and publish paginated reports.

The most appropriate used case of Azure Synapse Analytics is to perform very complex queries and aggregations on a large amount of relational data.