DP-900 Practice Questions

Which two of the following tools can be used to query data held in Azure SQL Database? Azure Data Studio. The query editor in the Azure portal. The psql utility.

Azure Data Studio. The query editor in the Azure portal.

Semi-structured data can be held in which of the following formats? Graph Databases Tables JSON Format Key Value Stores

Graph Databases JSON Format Key Value Stores

Azure Data Lake Storage has which of the following features? Select all options that apply. Hadoop Distributed File System (HDFS) support Directories and subdirectories support Support for Role-Based Access Control (RBAC) Structured data storage support

Hadoop Distributed File System (HDFS) support Directories and subdirectories support Support for Role-Based Access Control (RBAC)

Which of the following tools are available for connecting to Azure Database for MySQL? Select all options that apply. MySQL Workbench Azure Data Studio MySQL command line.

MySQL Workbench MySQL command line.

When moving your databases to the cloud you can avail of which of the following cloud models? Select all options that apply. Platform-as-a-service (PaaS) Software-as-a-service (SaaS) Infrastructure-as-a-Service (IaaS)

Platform-as-a-service (PaaS) Infrastructure-as-a-Service (IaaS)

Which of the following will allow for the creation of visualizations and reports? Power BI SQL Server Management Studio Azure Data Studio

Power BI

One of the parameters you specify when using the Azure CLI to create a new storage account is the 'sku' parameter. The sku is a combination of the performance tier and replication options that you wish to implement. These options include which of the following? Select all options that apply. Premium_LRS, Standard_GRS Premium_ZRS Premium_GZRS

Premium_LRS, Standard_GRS Premium_ZRS

Azure Databricks is an Apache Spark environment running on Azure, what are some of the features of Azure Databricks? Select all options that apply. Streaming Big data processing Machine learning Software-as-a-Service (SaaS) offering from Azure

Streaming Big data processing Machine learning

Tabular data that is represented by rows and columns in a database is referred to as?

Structured data

True or False? A key-value store is similar to a relational table except that each row can have any number of columns.

True

Azure Data Lake Analytics is an on-demand analytics job service that you can use to process big data. You write jobs that contain queries to transform data and extract insights. What language do you use to define a job? T-SQL U-SQL PL-SQL

U-SQL

Which of the following tools can be run from the desktop and directly from Azure? SQL Server Management Studio sqlcmd Azure Data Studio

sqlcmd

Using connections to different providers you can gain access to collections of ready-made visuals, pre-arranged in dashboards and reports. What are these ready-made visuals known as in Power BI? Scheduled refresh. App. Canvas.

App.

Documents stored in Azure Cosmos DB can not be modified using Azure Data Explorer and the SQL API. True False

False

Azure Cosmos DB provides the ability to create and manage databases using Azure CLI or Azure PowerShell. Which of the following command can you run to create a Cosmos DB account? Select all options that apply. az CosmosDBAccount create az cosmosdb create New-AzCosmosDBAccount

az cosmosdb create New-AzCosmosDBAccount

Which two of the following SQL statements are logically grouped as Data Definition Language (DDL) statements? ALTER DROP UPDATE

ALTER DROP

True or False? A data warehouse can only contain non-relational data.

False

True or False? In a relational database system, you store the information for entities in collections or containers.

False

True or False? SQL API queries can use JOIN clauses to connect fields in a document across different documents.

False

Azure Database for MySQL is a PaaS implementation of MySQL. Which of the following features are supported in Azure Database for MySQL. Select all options that apply. High availability Automatic backups and point-in-time restore support for MySQL 'SUPER' privilege account Scaling

High availability Automatic backups and point-in-time restore Scaling

The term big data refers to data that is too large or complex for traditional database systems. Systems that process big data have to perform rapid data ingestion and processing; they must have the capacity to store the results, and sufficient compute power to perform analytics over these results. Another option is to analyze operational data in its original location. This is referred to as? Hybrid analytical processing (HAP) Hybrid transactional analytical processing (HTAP) Hybrid transactional processing (HTP)

Hybrid transactional analytical processing (HTAP)

Denial of service (DoS) attacks are reduced by a SQL Database gateway service called DoSGuard. DoSGuard provides which two of the following features? Authenticates users. Tracks failed logins from IP addresses Encrypts all communications between a client and the database servers.

Tracks failed logins from IP addresses Encrypts all communications between a client and the database servers.

Apart from authentication and authorization, additional threat protection and assessment can be enabled when configuring Azure Database systems through which one of the following methods? Advanced Data Security Azure Private Endpoint Firewalls and virtual networks

Advanced Data Security

Azure HDInsight is a managed analytics service in the cloud and is based on which of the following? Apache Hive Apache Spark Apache Hadoop

Apache Hadoop

HDInsight can be used to analyze data using a collection of open-source tools. The ability to provide a clustered streaming service that can ingest data in real-time is provided by which service? Apache Storm Hadoop Map/Reduce Apache Kafka Apache Hive

Apache Kafka

HDInsight can be used to analyze data using a collection of open-source tools. The ability to provide a scalable, fault-tolerant platform for running real-time data processing applications is provided by which service? Apache Storm Apache Kafka Hadoop Map/Reduce Apache Hive

Apache Storm

Azure Blob storage is a service that enables you to store massive amounts of unstructured data, or blobs, in the cloud. Which of the following are types of blob supported in Azure? Select all options that apply. Append blobs Block blobs Table blobs Page blobs

Append blobs Block blobs Page blobs

A transaction is defined as a sequence of operations that are atomic and the transactional database must adhere to the ACID properties. In this context, what does ACID stands for?

Atomicity, Consistency, Isolation, Durability

Which of the following is an example of Unstructured data? An Employee table with columns named as Empid, EmpName, Salary. Audio and Video files. A table within SQL Server database.

Audio and Video files.

Azure Blob storage is a suitable repository for holding which kinds of content? Select all options that apply. Audio files Tables Images and videos

Audio files Images and videos

To create a container in an Azure Storage account you can use which of the following tools? Choose all options that apply. Azure Data Explorer Azure CLI Azure Portal

Azure CLI Azure Portal

Which of the following services should you deploy if you need to implement a non-relational database? The Gremlin API Azure Cosmos DB Azure SQL Database

Azure Cosmos DB

Which role is responsible for the following tasks? Enrolling users and maintaining system security. Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information.

Database Administrators

Who is responsible for the design, implementation, maintenance, and operational aspects of on-premises and cloud-based database solutions built on Azure data services and SQL Server?

Database Administrators

Hosting a database such as SQL Server on Virtual Machines is an example of which of the following? Software-as-a-Service (SaaS) Infrastructure-as-a-Service (Iaas) Platform-as-a-Service

Infrastructure-as-a-Service (Iaas)

True or False? A data lake and a data warehouse both store large quantities of data. However, a data lake holds raw data while a data warehouse holds structured information.

True

True or False? A hybrid deployment is a system where part of the operation runs on-premises and part in the cloud.

True

True or False? Azure SQL Database uses a clustered topology to provide high availability.

True

True or False? Using Azure Data Services for your database management system provides the same features as an on-premises SQL Server database management system.

False

Which of the following is true when implementing non-relational databases? Non-relational databases contain tables with fixed-column records. Non-relational databases require data normalization techniques to reduce data duplication. Non-relational databases are either schema-free or have relaxed schemas.

Non-relational databases are either schema-free or have relaxed schemas.

Which of the following are examples of unstructured data? Select all options that apply. Messaging Audio Point-of-Sale Data Video

Messaging Audio Video

Am Azure Resource Manager template describes the Azure service that you want to deploy in a text file, in a format known as JSON. Which two of the following commands can be used to send the template to Azure? 'New-AzResourceGroupDeployment' 'az deployment group create' 'new az group deployment'

'New-AzResourceGroupDeployment' 'az deployment group create'

Azure Table Storage provides high-availability in a single region, how many times is data for each table is replicated? 5 2 3

3

What is the process of obtaining and importing data for immediate use or storage in a database called? Ingestion Consumption

Ingestion

Which of the following SQL statements are grouped as Data Manipulation Language (DML) statements? Select all options that apply. SELECT ALTER DELETE

SELECT DELETE

In Azure Data Factory you define the work performed as a pipeline of operations. Which of the following statements describe the features of an Azure Data Factory Pipeline? You can create pipelines using the graphical user interface and custom code. You can create pipelines using custom code only. You can create pipelines using the graphical user interface only.

You can create pipelines using the graphical user interface and custom code.

What Power BI feature can you use to share sets of unrelated of visualizations? Report Dashboard Dataset

Dashboard

Which role is responsible for the following tasks: Making large or complex data more accessible, understandable, and usable. Creating charts and graphs, histograms, geographical maps, and other visual models Transforming, improving, and integrating data from many sources Combining the data result sets across multiple sources

Data Analysts

Who is responsible for designing and building scalable models, cleaning and transforming data, and enabling advanced analytics capabilities through reports and visualizations?

Data Analysts

Collaborating with stakeholders to design and implement data-related assets that include data ingestion pipelines, cleansing and transformation activities, and data stores for analytical workloads, is the responsibility of which one of the following roles?

Data Engineers

Which role is responsible for the following tasks? Developing processes for creating and retrieving information from data sets. Using programming languages and tools to examine the data. Identifying ways to improve data reliability, efficiency, and quality. Researching industry and business questions

Data Engineers

What are key roles related to dealing with data in an organization?

Data Engineers, Data Analysts, Database Administrators

Cosmos DB provides several options for uploading data to a Cosmos DB database and querying that data. Which of the following tools can be used directly to perform data operations in Cosmos DB? Data Explorer SQL Server Management Studio Azure Data factory

Data Explorer Azure Data factory

Which of the following is an example of a streaming dataset? List of employees working for a company. Sales data for the past month. Data from sensors and devices.

Data from sensors and devices.

Which of the following analytics helps answer questions about what has happened based on historical data? Predictive analytics Descriptive analytics Diagnostic analytics

Descriptive analytics

Which of the following analytics helps answer questions about why things happened? Cognitive analytics Diagnostic analytics Prescriptive analytics

Diagnostic analytics

As part of data processing, two approaches can be undertaken. What is the process of retrieving the raw data and transforming it referred to as? ELT ETL

ETL

Azure Database for MariaDB is a PaaS implementation of the MariaDB management system. Which of the following features are supported in Azure Database for MariaDB? Select all options that apply. Easy scaling SUPER privilege High availability

Easy scaling High availability

True or False? PolyBase allows T-SQL queries to join data from external sources to relational tables in an instance of SQL Server. To enable this feature client connection software is required.

False

True or False? The default connectivity for Azure Cosmos DB and Azure Storage is to disable access to the world at large.

False

True or False? The default connectivity for Azure relational data services is to allow access from anywhere.

False

True or False? To ingest data in Azure Data Factory, the source data needs to be in Relational Data Format.

False

True or False? When connecting to Azure SQL via the Query editor in Azure Portal you will be prompted for credentials. Authorisation is only possible using Azure Active Directory password authentication.

False

True or False? You can only use Azure CLI and Azure Powershell to retrieve a blob from Azure Storage and save it as a local file on your computer.

False

Which one of the following visuals can be used to display how a value differs in proportion across a geography or region. Treemap A dot plot chart Filled map

Filled map

Azure SQL Database deployment options can restrict some of the administrative features available to SQL Server. Which of the following will provide the most administrative control? Single Database Elastic Pool Managed Instance

Managed Instance

Sometimes when ingesting data, the data you're bringing in can have different column names and data types to those required by the output. In these cases, which of the following options can you use to transform your data from the input format to the output format. Linking Mapping Renaming

Mapping

Power BI is composed of which of the following components? Select all options that apply. Mobile Power BI apps An online Platform-as a Service (PaaS) service A Microsoft Windows desktop application An online Software as a Service (SaaS) service

Mobile Power BI apps A Microsoft Windows desktop application An online Software as a Service (SaaS) service

Azure SQL Database is commonly used for which of the following cases? Select all options that apply. Modern cloud applications that need to use the latest stable SQL Server features. Migrating on-premises management systems to virtual machines in the cloud. Applications that require high availability.

Modern cloud applications that need to use the latest stable SQL Server features. Applications that require high availability.

Graph databases enable you to store entities, but the main focus is on the relationships that these entities have with each other. Which of the following statements is true of graph databases? Nodes are similar to instances of entities. Edges specify the relationships between the Nodes. Edges are similar to instances of entities, and Nodes specify the relationships between the Edges.

Nodes are similar to instances of entities. Edges specify the relationships between the Nodes.

In Azure Data Factory ingestion tasks can be triggered using which of the following components? Linked service Pipeline CSV File

Pipeline

If you are connecting to a cloud database service from outside Azure, such as an on-premises application, your connections have a default connection policy of Proxy. Proxy means that after establishing a connection through a gateway all subsequent requests go directly to the database. Proxy means that after establishing a connection through a gateway all subsequent requests flow through the gateway

Proxy means that after establishing a connection through a gateway all subsequent requests flow through the gateway

Azure Data Lake is a repository for large quantities of which form of data? Cleaned data Formatted data Raw data

Raw data

Azure Table Storage splits a table into partitions. Which of the following are features of partitions? Select all options that apply. Partitions are linked to each other. Rows that share the same partition key will be stored together. The grouping of related rows is based on a common property or partition key.

Rows that share the same partition key will be stored together. The grouping of related rows is based on a common property or partition key.

Azure SQL Database deployment is available with several options. Which of the following options are available for deploying Azure SQL Database? Select all options that apply. Virtual Machine Single Database Elastic Pool

Single Database Elastic Pool

When running a SQL Server on a virtual machine, which of the following is the responsibility of the Tenant? All software installation and maintenance tasks are managed by the provider, but you must do your backups. Backups are automated, but it is your responsibility to install and maintain the software for the Database management system. Software installation and maintenance, as well as backups, are the responsibility of the tenant.

Software installation and maintenance, as well as backups, are the responsibility of the tenant.

Which of the following is a common usage of Azure Blob Storage? Select all options that apply. Storing data for backup, restore, and disaster recovery Storage of tabular relational data Streaming video and audio

Storing data for backup, restore, and disaster recovery Streaming video and audio

Azure Synapse Analytics is an integrated analytics service that allows organizations to gain insights quickly from all their data from both data warehouses and big data analytics systems​. Azure Synapse is composed of which of the following elements? Choose all options that apply. Synapse SQL pool Synapse NoSQL pool Synapse Pipelines Synapse Spark pool

Synapse SQL pool Synapse Pipelines Synapse Spark pool

What tools does Azure provide to assist in the provision of services? The Azure command-line interface (CLI) Azure Data Studio Azure PowerShell The Azure portal

The Azure command-line interface (CLI) Azure PowerShell The Azure portal

The following syntax creates a table called customers in Azure PostgreSQL CREATE TABLE customers( customer_id SERIAL PRIMARY KEY, name VARCHAR (50) NOT NULL, location VARCHAR (50) NOT NULL, email VARCHAR (50) NOT NULL ); What does the parameter 'Not Null' mean in this context? The column is not allowed to contain null values. The default for the column will be an empty string.

The column is not allowed to contain null values.

You can use shared access signatures (SAS) to grant limited rights to resources in an Azure storage account for a specified time. This feature enables applications to access resources such as blobs and files, without requiring that they're authenticated first. To what can Shared Access Signatures be granted? Select all options that apply. The entire service Objects owned by that SAS Token Containers Individual objects such as blobs and files

The entire service Containers Individual objects such as blobs and files

Unlike traditional relational databases such as SQL Server, Azure Cosmos DB is a multi-model NoSQL database management system. Cosmos DB manages data as a partitioned set of documents. Which of the following are features of Azure Cosmos DB? Select all options that apply. The structure of the document is proprietary to Microsoft. The fields in each document can vary. A document is a collection of fields, identified by a key.

The fields in each document can vary. A document is a collection of fields, identified by a key.

When using standard storage accounts. You can select between different Access Tiers Hot and Cool. Which of the following statements are true? The hot access tier has higher storage costs but the lowest access costs - The cool access tier has lower storage costs and higher access costs. The hot access tier has lower storage costs but the highest access costs - The cool access tier has higher storage costs and lower access costs.

The hot access tier has higher storage costs but the lowest access costs - The cool access tier has lower storage costs and higher access costs.

A key-value store is a type of NoSQL database for inserting and querying data. Each data item in a key-value store has two elements, a key, and a value. Which of the following statements is correct? The key holds the data for the item and the value uniquely identifies the item. The key uniquely identifies the item, and the value holds the data for the item.

The key uniquely identifies the item, and the value holds the data for the item.

What is the purpose of data ingestion? To capture data coming into a data warehouse system as quickly as possible. To create visualizations on data as a result of data analysis. To carry out complex data transformations against data that has been received from external sources.

To capture data coming into a data warehouse system as quickly as possible.

PolyBase is used to carry out which of the following? To ingest streaming data using Azure Databricks. To query data from external data sources using SQL Server. To orchestrate activities in Azure Data Factory.

To query data from external data sources using SQL Server.

SQL statements are part of the SQL standard, many database management systems also have their additional proprietary extensions to handle the specifics of that database management system. Which of the following dialects is used by the Microsoft SQL Server and Azure SQL Database? pgSQL PL/SQL. Transact-SQL

Transact-SQL

Azure Synapse Analytics is a generalized analytics service. Which technologies does it support to process data? Choose all options that apply. Transact-SQL Spark PL/SQL

Transact-SQL Spark

True or False? A single dataset that Power BI uses to create its visualizations can be data extracted from multiple sources. For example, it could be extracted from database fields, a website table, an Excel table, and some online results of an email campaign. True False

True

True or False? Microsoft Power BI is a powerful visualization platform, to create rich, graphical dashboards and reports over data that can vary dynamically.

True

True or False? The command-line utility AzCopy can be used for Transferring large quantities of files in and out of Azure File storage as well as detecting and restarting transfer failures. True False

True

True or False? The term lift and shift refers to database migrations and applications which require access to operating system features that might not be supported at the PaaS level.

True

True or False? The term wrangling refers to the process of transforming and mapping raw data into a more useful format for analysis purposes.

True

True or False? When using Azure SQL Managed Instances all communications are encrypted and signed using digital certificates. True False

True

You are running a MySQL database on-premises and want to move the data to a database running the corresponding data services in Azure. What is the best way to transfer the data? Export the data from the on-premises database and manually import it into a database running in Azure. Upload a MySQL database backup file to the database running in Azure. Use the Azure Database Migration Service (DMS).

Use the Azure Database Migration Service (DMS).

Unstructured Data can be made up of what?

Video files, Image Files, Audio Files, Binary Data

Everything you do in Microsoft Power BI can be broken down into a few basic building blocks. Which of the following are building blocks of Power BI? Visual Studio, C#, and JSON files. Databases, Tiles, dashboards, mobile devices. Visualizations, datasets, reports, dashboards, and tiles.

Visualizations, datasets, reports, dashboards, and tiles.

What do you use to write Databricks applications? A Notebook An XML File A Yaml File

A Notebook

What is a linked service in Data Factory? A linked service is a connection created by a data engineer to connect on-premises and cloud-based storage for file shares. A linked service provides the information needed for Data Factory to connect to a source or destination. A linked service is a connection created by a data engineer for data visualizations.

A linked service provides the information needed for Data Factory to connect to a source or destination.

True or False? A foreign key uniquely identifies each row in a table. No two rows can share the same primary key.

False

True or False? In an Azure Table Storage table, all rows in a table must have a key, and the columns in each row must be the same.

False

You create Azure File storage in a storage account. Currently, Azure File Storage enables you to share how much data in a single storage account? 100TB 50TB 500TB

100TB

Connections to Azure SQL Database server communicate over what port? 3306 5432 1433

1433

What port is used to communicate with Azure Database for PostgreSQL? 5432 3306 1433

5432

Which of the following statements accurately describe an Azure Data Factory? A Relational Database management tool A Non-Relational Database management tool A Data integration Service A Data Query Service

A Data integration Service

Before creating non-relational data services such as Azure Cosmos DB or Blob Storage what must you create? A Storage Account A Management Group A Resource Group

A Storage Account

A Power BI dashboard is a collection of visuals. Which of the following are features of a Dashboard? Choose all options that apply. A dashboard can span multiple pages. A dashboard must fit on a single page. you can share dashboards with other users or groups.

A dashboard must fit on a single page. you can share dashboards with other users or groups.

Which of the following are features of a document database? Select all options that apply. A document database uses a key-value store. A document store requires that all documents have the same structure. A document typically contains the entire data for an entity. A document database can store data in a format such as JSON, XML, or YAML format

A document typically contains the entire data for an entity. A document database can store data in a format such as JSON, XML, or YAML format

Azure Synapse Analytics leverages massively parallel processing (MPP) architecture. Which of the following does this architecture entail? Select all options that apply. A pool of Control nodes A pool of Compute nodes A single Compute node A single Control node

A pool of Compute nodes A single Control node

Which of the following is a characteristic of a relational database table? A row in a table represents a single entity or record. Different rows in the same table can contain different columns All data must be stored as character strings

A row in a table represents a single entity or record

Azure Data Lake is a repository for large quantities of raw data. As part of the data processing pipeline, it uses a staging area. What does the term staging area mean? A staging area is where data is held temporarily before being processed. A staging area is where data is held temporarily after being processed.

A staging area is where data is held temporarily before being processed.

The main characteristics of a relational database include: Select all options that apply. A table can contain any number of rows. All data is tabular. Rows in the same table can have different numbers of columns. Entities are modeled as Tables.

A table can contain any number of rows. All data is tabular. Entities are modeled as Tables.

Which of the following are advantages of using Azure Table Storage tables over traditional relational databases? Select all options that apply. Referential integrity is maintained by using relationships between the partitions. A table can hold semi-structured data. There's no need to map and maintain the complex relationships typically required by a normalized relational database.

A table can hold semi-structured data. There's no need to map and maintain the complex relationships typically required by a normalized relational database.

Which of the following may have an adverse effect on your system by adding more indexes? A read-only table. A table that contains data that is modified infrequently. A table that is queried infrequently, but subject to a large number of inserts, updates, and deletes.

A table that is queried infrequently, but subject to a large number of inserts, updates, and deletes.

Which of the following are common options for processing data in Microsoft Azure? Choose all options that apply. Azure Data Studio Azure Data Factory Azure Synapse Analytics Azure Databricks

Azure Data Factory Azure Synapse Analytics Azure Databricks

Deployment of the Hyperscale (Citus) option which scales queries across multiple server nodes to support large database loads is a deployment option for which Azure Database service? Azure Database for PostgreSQL Azure Database for MySQL Azure Database for SQL Azure Database for MariaDB

Azure Database for PostgreSQL

When provisioning Azure Databases, support for ultra-high performance workloads through a feature called Hyperscale is available for which of the following? Azure Database for MySQL Azure SQL Azure Database for PostgreSQL

Azure Database for PostgreSQL

Which tool can be used to assist in creating custom Dashboards that will help in graphically organizing your resources in Azure? Azure Marketplace Azure Portal

Azure Portal

Microsoft provides two graphical tools you can use to create and manage file shares in Azure Storage. These are? Select all options that apply. Azure Portal Azure Storage Explorer Azure Data Studio

Azure Portal Azure Storage Explorer

Provisioning is the act of running a series of tasks to create and configure a service such as Azure SQL Database. Which of the following tools can be used to provision the service in Azure? Select all options that apply. Azure Resource Manager templates Azure Data Studio The Azure portal SQL Management Studio

Azure Resource Manager templates The Azure portal

Azure Data Services are available for a range of popular SQL-based database solutions. Which of the following database management systems are supported as a service in Azure? Select all options that apply. Azure SQL Database Oracle Database PostgreSQL

Azure SQL Database PostgreSQL

Which of the following is the common flow of activity that would generally be carried out to create reports or visualizations in Power BI? Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop. Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact with the report in the Power BI service. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.

Which one of the following terms refers to the technologies, applications, and practices related to the collection, integration, analysis, and presentation of business information? Reporting Data Visualisations Business Intelligence

Business Intelligence

The SQL API includes many common mathematical and string operations. What are the following operators are referred to as? =, !=, <, >, <=, >=, <> Unary Comparison Arithmetic Logical

Comparison

Using a JOIN clause in an SQL API query does what? Connects data from different tables Connects fields in a document with fields in a subdocument

Connects fields in a document with fields in a subdocument

Access management for cloud resources is a critical function for any organization that uses the cloud. Azure role-based access control (Azure RBAC) using role assignments helps you manage who has access to your Azure resources and what they can do with those resources. Which of the following are elements of role assignments? Select all options that apply. A Scope A Role Definition A Security principal A Resource Group

A Scope A Role Definition A Security principal

Which of the following features in Power BI can you use to generate an individual chart or color-coded map of data? A Report A Dataset A Visualization

A Visualization

In the SQL API query syntax, what is the DISTINCT operator used for? Allows the select query to eliminate duplicates in the result data. Forces the select query to return all occurrences of a specific word.

Allows the select query to eliminate duplicates in the result data.

Azure Table storage is held in the cloud and requires the creation of which of the following? File Shares An Azure storage account Azure Blob storage

An Azure storage account

Azure Table Storage implements the NoSQL key-value model. What is a NoSQL key-value model? A table structure made up of Primary and Foreign keys An item stored as a set of fields and identified by a unique key

An item stored as a set of fields and identified by a unique key

Which of the following statements best defines Security Principal in Azure? A named collection of permissions that can be granted to a service. An object such as a user, group or service, that requires access to Azure resources. A set of resources managed by a service to which you can grant access.

An object such as a user, group or service, that requires access to Azure resources.

Within a single region, Cosmos DB uses a cluster of servers. This approach helps to improve scalability and availability. A copy of all data is held in each server in the cluster. This can lead to data inconsistency. Azure Cosmos DB enables configuration as to how these inconsistencies should be handled. Which option ensures that changes will appear in order? Notwithstanding, there may be a delay before they become visible and during this period applications may see old data. Bounded Staleness Strong Session Eventual Consistent Prefix

Consistent Prefix

Azure Cosmos DB organizes data as a collection of documents stored in containers. And these containers are held in a database. Before setting up a database what must you do? Build and Deploy a new Virtual Machine in your tenant to store the database Create an account Create a database in Azure SQL Database

Create an account

The process of taking data in its raw form, cleaning the data, and then converting it into a more meaningful format such as tables, graphs, documents, etc. is referred to by which of the following terms? Data Processing Data Manipulation Data Ingestion

Data Processing

In an Azure Table Storage table in what format is data is generally held? Normalised Denormalised

Denormalised

Data Factory provides an orchestration engine. What does the term orchestration mean in this context? Direct, control and connect services Transform Data Analyse data in a data warehouse

Direct, control and connect services

You can replicate data from an Azure Database for PostgreSQL server to a read-only server. Azure Database for PostgreSQL supports replication from the master server for a total of how many replicas? Two Three Five

Five

Blobs can be organized into a hierarchy using which of the following structures? Folders, Containers, Storage Accounts Storage Account, Containers, Folders Containers, Storage Accounts, Folders

Folders, Containers, Storage Accounts

A SQL API SELECT query can include which of the following? Select all options that apply. From Where Order By Update

From Where Order By

Non-relational databases are suitable for which of the following scenarios? Select all options that apply. Gaming Web and mobile applications. Wages Application IoT and telematics

Gaming Web and mobile applications. IoT and telematics

Azure Database for PostgreSQL single-server deployment option comes in three pricing tiers. Which of the following tiers are available for Azure Database for PostgreSQL Select all options that apply. General Purpose Processor Optimised Basic

General Purpose Basic

Azure Storage offers a selection of options on how your Data in an Azure Storage account is replicated to provide high levels of availability. Which of the following are valid options? Select all options that apply. Read-access Local-redundant storage (RA-LRS) Geo-redundant storage (GRS) Locally redundant storage (LRS)

Geo-redundant storage (GRS) Locally redundant storage (LRS)

You can use HDInsight to analyze data using frameworks such as Hadoop Map/Reduce, Apache Spark, Apache Hive, Apache Kafka, Apache Storm, R, and more. Apache Hive provides which of the following features? A clustered streaming service that can ingest data in real-time. A scalable, fault-tolerant platform for running real-time data processing applications. Interactive SQL-like facilities for querying, aggregating, and summarizing data. The ability to split a task over a large dataset into a series of smaller tasks.

Interactive SQL-like facilities for querying, aggregating, and summarizing data.

The Cosmos DB SQL API supports a dialect of SQL for querying documents using SELECT statements similar to using select statements with relational databases. The SQL API returns results in what format? JSON Yaml XML BSON

JSON

Which one of the following visuals displays the major contributors to a selected result or value? Line charts Key influencers chart Scatter chart

Key influencers chart

Which of the following are categories of NoSQL? Select all options that apply. Key-value stores Column family databases Graph databases Document databases Tabular databases

Key-value stores Column family databases Graph databases Document databases

What are advantages of Batch Processing?

Large volumes of data can be processed at a convenient time and It can be scheduled to run at a time when computers or systems might otherwise be idle.

What can an index on a table do? Create a structure made up of rows and columns that can be used for storing data Create a virtual table based on the result set of a query Locate rows in a table quickly by referencing an indexed value.

Locate rows in a table quickly by referencing an indexed value.

Which one of the following visuals displays a tabular structure that summarizes data? Key influencers chart Matrix chart Bar and Column chart

Matrix chart

Which of the following are benefits of a cloud-based approach to Database Management Systems? Select all options that apply. Organizations only have to pay for the resources they use. The organization only incurs Capital Expenditure. Scalability Data can be backed up regularly.

Organizations only have to pay for the resources they use. Scalability Data can be backed up regularly.

When connecting to a database from within another Azure service, such as a web application running under Azure App Service, your connections by default have a connection policy of Redirect. Which of the following is implemented with the connection policy of Redirect? Redirect means that after establishing a connection through a gateway all subsequent requests go directly to the database. Redirect means that after establishing a connection through a gateway all subsequent requests flow through the gateway

Redirect means that after establishing a connection through a gateway all subsequent requests go directly to the database.

Azure Cosmos DB uses the concept of Request Units per second (RU/s) to manage the performance and cost of databases. If you underprovision (by specifying too few RU/s), Cosmos DB will start throttling performance. What effect will this have on requests to access the database? The requests will be aborted immediately. Requests will be asked to retry later. Your database will halt for a period of time.

Requests will be asked to retry later.

Using the SQL API in Azure Cosmos DB you can use aggregate functions to summarize data in SELECT queries. What does the Count(p) function do? Select all options that apply. Returns the sum of all the instances of field p in the result set. Returns the number of instances of field p in the result set.

Returns the sum of all the instances of field p in the result set. Returns the number of instances of field p in the result set.

Structured data is typically stored in which of the following? Azure Cosmos DB SQL Server or Azure SQL Database Azure Blob storage

SQL Server or Azure SQL Database

When migrating on-premises SQL databases to Azure, which type of migration requires the least amount of reconfiguration? SQL server running on a virtual machine Azure SQL Single Database Azure SQL Database managed instance

SQL server running on a virtual machine

When connecting to a data source in Power BI the canvas shows the available sources of data in the Power BI service. In addition to common data sources like Microsoft Excel files, databases, or Microsoft Azure data, Power BI can just as easily connect to a wide range of cloud services such as Salesforce, Facebook, and Google Analytics. This connection feature is available through which type of cloud service? PaaS providers IaaS providers SaaS providers

SaaS providers

Non-relational data generally falls into which two categories. Which of the following are categories of non-relational data? Select all options that apply. Structured Semi-Structured Non-Structured

Semi-Structured Non-Structured

An Azure table enables you to store what kind of data? Unstructured Data Structured Data Semi-structured Data

Semi-structured Data

Which of the following are features of Semi-structured entities? The fields must be the same in every entity. Semi-structured data is data that contains fields. You define the fields that you need on a per-entity basis.

Semi-structured data is data that contains fields. You define the fields that you need on a per-entity basis.

Azure File Storage exposes file shares using what protocol? HTTPS Server Message Block 2.0 Server Message Block 3.0

Server Message Block 3.0

Within a single region, Cosmos DB uses a cluster of servers. This approach helps to improve scalability and availability. A copy of all data is held in each server in the cluster. This can lead to data inconsistency. Azure Cosmos DB enables configuration as to how these inconsistencies should be handled. Which form of consistency is sometimes known as 'read your own writes'? Bounded Staleness Session Eventual Consistent Prefix Strong

Session

You can use either the Azure command line interface (CLI) or Azure PowerShell to create documents and containers on Azure CosmosDB. Which of the following is an example of a create database command using Azure Powershell? Set-AzCosmosDBSqlDatabase az cosmosdb sql database create

Set-AzCosmosDBSqlDatabase

Some of the benefits for management when using Azure File Storage include? Select all options that apply. Share server data across on-premises and cloud Store files of up to 100TB each in the cloud Migrate existing applications to the cloud

Share server data across on-premises and cloud Migrate existing applications to the cloud

Which of the following statements describe Online Transactional Processing (OLTP)? Systems that are often high-volume, sometimes handling many millions of transactions in a single day. Systems designed to support business users who need to query data and gain a big picture view of the information held in a database.

Systems that are often high-volume, sometimes handling many millions of transactions in a single day.

Blob storage provides three access tiers, which help to balance access latency and storage cost. Which of the following are valid tiers for Blob storage? Select all options that apply. The Archive Tier The Hot Tier The Warm Tier The Cool Tier

The Archive Tier The Hot Tier The Cool Tier

True or False? Azure Data Lake Store provides a hierarchical file system, granular security over data and supports both raw data (blobs) and structured data.

True

True or False? Azure Data Studio is a cross-platform database administration tool that provides a graphical user interface for managing many different database systems and provides connections to: On-premises SQL Server databases Azure SQL Database PostgreSQL Azure SQL Data Warehouse

True

True or False? Azure offers several PaaS solutions for relational databases including: Azure SQL Database Azure Database for PostgreSQL Azure Database for MySQL Azure Database for MariaDB

True

True or False? Batch processing is suitable for handling large datasets efficiently while Stream processing is intended for individual records or micro-batches consisting of few records.

True

True or False? Power BI provides native mobile BI apps for Windows, iOS, and Android.

True

True or False? SQL Server Integration Services (SSIS) is an on-premises utility that can extract and transform data from a wide variety of sources. These packages can be run as part of a data factory pipeline in the cloud.

True

True or False? SQL Server Management Studio enables you to generate Transact-SQL scripts allowing for the scheduling and automation of many common tasks.

True

True or False? Some relational database management systems support clustered indexes that physically reorganize a table by the index key.

True

True or False? The primary key indicates the column (or combination of columns) that uniquely identify each row in a table. A Foreign Key is a reference, or link to the primary key of another table and is used to maintain the relationships between tables in Relational Databases.

True

True or False? The process of splitting data into a large number of narrow, well-defined tables with references from one table to another is referred to as normalization?

True

True or False? The term JSON stands for JavaScript Object Notation.

True

Azure Analysis Services supports online analytical processing (OLAP) and has some functional overlaps with Azure Synapse Analytics. Which of the following scenarios would be more suitable for processing with Azure Synapse Analytics service over Azure Analysis Service? High read concurrency (thousands of users) Rapid dashboard development from tabular data Very high volumes of data (multi-terabyte to petabyte sized datasets)

Very high volumes of data (multi-terabyte to petabyte sized datasets)

Databases are managed using a database management system (DBMS). The DBMS handles which of the following aspects of a database? Select all options that apply. Network availability. Who can access the data. Where and how data is stored.

Who can access the data. Where and how data is stored.

Which of the following are characteristics of a View? Select all options that apply. A view is limited to querying a single table. You can query the view and filter the data in much the same way as a table. A view is a virtual table based on the result set of a query.

You can query the view and filter the data in much the same way as a table. A view is a virtual table based on the result set of a query.

Azure Cosmos DB enables you to replicate databases and containers in your account across multiple regions. After configuring replication you can use the Replicate data globally page to configure specific settings Which of the following are settings included in the Replicate data globally page? Select all options that apply. You can set replication to multiple regions. By default, all regions support write operations. Configure automatic failover to help ensure high availability.

You can set replication to multiple regions. Configure automatic failover to help ensure high availability.