Your team currently has the following two tables in an Azure SQL database. You have to search for rows which gives you the student’s name and the course they have registered for. Which of the following would you include in the SELECT statement for this requirement?

Your company is planning on hosting several Azure Cosmos DB accounts. Each account has a separate requirement which is given below.

Which of the following would you choose as the underlying API for newaccount1000?

Your company is planning on hosting several Azure Cosmos DB accounts. Each account has a separate requirement which is given below.

Which of the following would you choose as the underlying API for newaccount2000?

Your company is planning on hosting several Azure Cosmos DB accounts. Each account has a separate requirement which is given below.

Which of the following would you choose as the underlying API for newaccount3000?

Your company is planning on developing an environment wherein events from an external source are going to be streamed onto Azure Event Hubs. Which of the following can be used to take and process the data from Azure Event Hubs?

Your company needs to develop a system that caters to the following requirements

1) Run a batch job on a daily basis that would read data from an external source

2) The batch job would need to store the data in parquet format in a data store on Azure

3) A separate analytical system would be in place that would use notebooks to process the parquet-based data

You need to choose the right service for each requirement.

Which of the following would go into Service 1?

Your company needs to develop a system that caters to the following requirements

1) Run a batch job on a daily basis that would read data from an external source

2) The batch job would need to store the data in parquet format in a data store on Azure

3) A separate analytical system would be in place that would use notebooks to process the parquet-based data

You need to choose the right service for each requirement. Which of the following would go into Service 2?

Your company needs to develop a system that caters to the following requirements

1) Run a batch job on a daily basis that would read data from an external source

2) The batch job would need to store the data in parquet format in a data store on Azure

3) A separate analytical system would be in place that would use notebooks to process the parquet-based data

You need to choose the right service for each requirement.

Which of the following would go into Service 3?

Your team is planning on using Azure Data Factory. It would be used to transfer data on a daily basis from Azure Data Lake Gen 2 storage accounts onto an Azure SQL data warehouse in Azure Synapse Analytics. Which of the following in Azure Data Factory is meant to represent a logical grouping of activities that are used to perform a task?

Your team is planning on using Azure Data Factory. It would be used to transfer data on a daily basis from Azure Data Lake Gen 2 storage accounts onto an Azure SQL data warehouse in Azure Synapse Analytics. Which of the following in Azure Data Factory is meant to represent connection strings to external data sources?

Your team is planning on using Azure Data Factory. It would be used to transfer data on a daily basis from Azure Data Lake Gen 2 storage accounts onto an Azure SQL data warehouse in Azure Synapse Analytics. Which of the following in Azure Data Factory is meant to represent a named view of the data?

Your team is planning on using Azure Data Factory. It would be used to transfer data on a daily basis from Azure Data Lake Gen 2 storage accounts onto an Azure SQL data warehouse in Azure Synapse Analytics. Which of the following in Azure Data Factory is meant to represent the compute infrastructure that is used to run the pipeline?

Your company’s data engineering team wants to make use of Apache Spark clusters for data analysis. They want to make use of a managed platform on Azure for this requirement. Can they make use of the Azure SQL Database service for this requirement?

Your company’s data engineering team wants to make use of Apache Spark clusters for data analysis. They want to make use of a managed platform on Azure for this requirement. Can they make use of the Azure Databricks service for this requirement?

Your company’s data engineering team wants to make use of Apache Spark clusters for data analysis. They want to make use of a managed platform on Azure for this requirement. Can they make use of the Azure Synapse Analytics service for this requirement?

Which of the following category does the Azure SQL database service come under?

Which of the following category does the Azure virtual machine service come under?

Your company’s team has just provisioned an Azure General Purpose V2 storage account. Which of the following service can be used to upload objects and ensure that each object has a unique URL?

Your company’s team has just provisioned an Azure General Purpose V2 storage account. Which of the following service can be used to map to share via the Server Message Block protocol?

Which of the following in Microsoft Power BI is used to create paginated reports that can be shared in the Power BI service?

Your data engineering team is looking at using Power BI. They have different visualization requirements when it comes to creating the reports. You have to decide on the right visualization based on the requirement. Which of the following visualization can be used to visualize data across multiple dimensions? It should also provide the facility to automatically aggregate data and enabling drill down of dimensions in any order.

Your data engineering team is looking at using Power BI. They have different visualization requirements when it comes to creating the reports. You have to decide on the right visualization based on the requirement. Which of the following visualization can be used to visualize a process that has stages and how items flow sequentially from one stage onto another?

Your data engineering team is looking at using Power BI. They have different visualization requirements when it comes to creating the reports. You have to decide on the right visualization based on the requirement. Which of the following visualization can be used to understand the factors that influence a key metric?

Which of the following can be used to host a data warehouse within Azure Synapse Analytics? It needs to be ensured that processing power is reserved for the data stored in the SQL tables.

You have to create an Azure Data Lake Gen 2 storage account. Which of the following needs to be enabled when creating the storage account for this requirement?

You have to create an Azure Data Lake Gen 2 storage account. After creating this account, will you have access to the file share service within the storage account?

Your team needs to create a set of storage accounts. Each storage account has different requirements when it comes to object storage. You need to set the access tier for the objects accordingly.

Which of the following would you set as the access tier for objects in appstore1000?

Your team needs to create a set of storage accounts. Each storage account has different requirements when it comes to object storage. You need to set the access tier for the objects accordingly.

Which of the following would you set as the access tier for objects in appstore2000?

Your team needs to create a set of storage accounts. Each storage account has different requirements when it comes to object storage. You need to set the access tier for the objects accordingly.

Which of the following would you set as the access tier for objects in appstore3000?

Your company is currently planning on creating an Azure SQL database resource. It will be used by a web application that will be hosted in Azure. Which of the following feature in the Azure SQL database can be used to protect sensitive data such as credit card numbers within tables in the SQL database?

Your data engineering team has deployed a set of Azure SQL databases. They are planning on using Azure Data Studio from their workstations to access the Azure SQL Databases. Can the Azure Data Studio tool be installed on a macOS machine?

Your data engineering team has deployed a set of Azure SQL databases. They are planning on using Azure Data Studio from their workstations to access the Azure SQL Databases. Can you use Azure Data Studio tool to perform a Backup/Restore of databases?

Your data engineering team has deployed a set of Azure PostgreSQL databases. They are planning on using Azure Data Studio from their workstations to access the Azure PostgreSQL Databases. Can you use Azure Data Studio tool to work with the Azure PostgreSQL databases?

Your team needs to develop two systems. Each system will serve a different purpose. Below are the key features for each system

1) System 1 – This system will be used to ingest all social media feeds. After every five minutes sentiment analysis needs to be conducted on the feeds.

Which of the following is the correct workload type for System 1?

Your team needs to develop two systems. Each system will serve a different purpose. Below are the key features for each system.

2) System 2 – This system will be used to load data from an external data once every day. The data will then be processed the following morning.

Which of the following is the correct workload type for System 2?

Your team needs to deploy a set of Azure SQL databases in a test environment. They want to be able to use the concept of Infrastructure as code for deployment of the databases. This is so that the same set databases can be deployed in multiple environments. Which feature of Azure can be used for this requirement?

Your data engineering team is planning on performing some tasks for an existing Azure SQL database with the use of Azure CLI and Azure PowerShell. Can you use the Azure CLI tool from a Linux-based workstation?

Your data engineering team is planning on performing some tasks for an existing Azure SQL database with the use of Azure CLI and Azure PowerShell. Can you use Azure PowerShell to add data to an existing table in an Azure SQL database?

What type of data analytics is the following statement a type of?

“How many 5- and 4-star reviews are we receiving for each product”

What type of data analytics is the following statement a type of?

“Why are we receiving 2-star reviews for certain products”

What type of data analytics is the following statement a type of?

“What will happen if we launch a new product in the market”

What type of data analytics is the following statement a type of?

“What actions should we take to boost the reviews of existing products”

In an ELT-based system where does the transformation of data take place?

Which of the following is a system that can be used as an OLTP system?

Your company is currently using Azure Data Lake Gen2 as a data store. Here data is being streamed onto the data store via Azure Event Hubs. The data is then taken on a daily basis via Azure Data Factory. And Azure Data Factory sends the data onto a SQL data warehouse in Azure Synapse Analytics.

Here where is the data being extracted from?

Your company is currently using Azure Data Lake Gen2 as a data store. Here data is being streamed onto the data store via Azure Event Hubs. The data is then taken on a daily basis via Azure Data Factory. And Azure Data Factory sends the data onto a SQL data warehouse in Azure Synapse Analytics.

Here where is the data being loaded into?

Your team needs to set up a set of data stores. Below are the key requirements for each data store

Which of the following would you consider as the data store for Store3?

Your company is planning on hosting an e commerce system on Azure. They want to setup services that will be needed based on the below requirements

1) The ecommerce system will need to read and write data to an Azure SQL database

2) Monthly data will be transferred to an Azure SQL data warehouse for performing data analytics

Which of the following processing type is being performed by the Azure SQL database service?

Your company is planning on hosting an e commerce system on Azure. They want to setup services that will be needed based on the below requirements

1) The ecommerce system will need to read and write data to an Azure SQL database

2) Monthly data will be transferred to an Azure SQL data warehouse for performing data analytics

Which of the following processing type is being performed by the Azure SQL data warehouse service?

Which of the following service can be used to transfer the data from the Azure SQL database onto the SQL Data Warehouse?

Your team is planning on using Azure Data Factory. Which of the following can be used to visually design the data transformations in Azure Data Factory?

Your company needs to setup a set of SQL databases on Azure. Each database has a separate requirement which is given below

Which of the following would you choose as the implementation service for Database 1?

Your company needs to setup a set of SQL databases on Azure. Each database has a separate requirement which is given below

Which of the following would you choose as the implementation service for Database 2?

Your company needs to setup a set of SQL databases on Azure. Each database has a separate requirement which is given below

Which of the following would you choose as the implementation service for Database 3?

Your team is planning on using Synapse SQL in an Azure Synapse Analytics workspace. Which of the following is used by Synapse SQL to keep user data safe?

Your team is planning on using Synapse SQL in an Azure Synapse Analytics workspace. Which of the following is the front end that interacts with all applications and connections?

Your team is planning on using Synapse SQL in an Azure Synapse Analytics workspace. Which of the following is a basic unit of storage and processing for parallel queries that run on distributed data in a dedicated SQL pool?

A company wants to host a data store on Azure. They want the data store to reflect the organization hierarchy of its employees. Which of the following would be the ideal data store type to use for this requirement?

Your development team is planning on using SQL Management Studio to work with various data stores on Azure. Can you use SQL Server Management Studio to connect to a SQL Server hosted on an Azure virtual machine?

Your development team is planning on using SQL Management Studio to work with various data stores on Azure. Can you use SQL Server Management Studio to connect to an Azure SQL Database?

Your development team is planning on using SQL Management Studio to work with various data stores on Azure. Can you use SQL Server Management Studio to connect to an Azure Cosmos DB database?

Your team is planning on setting up an Azure SQL database. Which of the following maps to a database object that contains all the database in the database?

Your team is planning on setting up an Azure SQL database. Which of the following maps to a virtual table who contents are defined by a query?

Your team is planning on setting up an Azure SQL database. Which of the following maps to a structure that is used to speed up the retrieval of rows from a table or view?

Your team has created an Azure Cosmos DB account based on the SQL API. They have defined a container with a name of customer. The partition key for the container is customercity. Can they change the partition key for the container to customerid?

Your team has created an Azure Cosmos DB account based on the SQL API. They have defined a container with a name of customer. Can multiple items have the same partition key?

Your team has created an Azure Cosmos DB account based on the SQL API. Which of the following is an expression of the cost of all database operations when it comes to Azure Cosmos DB?

Your team has created an Azure Cosmos DB account based on the SQL API. You need to assign the number of Provisioned Throughput units. Can you assign the number of Provisioned Throughput units at the Account level?

Your team has created an Azure Cosmos DB account based on the SQL API. You need to assign the number of Provisioned Throughput units. Can you assign the number of Provisioned Throughput units at the Container level?

Your team has created an Azure Cosmos DB account based on the SQL API. You need to assign the number of Provisioned Throughput units. Can you assign the number of Provisioned Throughput units at the database level?

Your team has a SQL Script that contains the following statements

CREATE TABLE Course

(

CourseID int,

CourseName varchar(1000),

Rating numeric(2,1)

)

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(1,'AZ-204 Developing Azure solutions',4.5)

SELECT * FROM Course

1. Which of the following statement types does the following statement come under?

CREATE TABLE Course

(

CourseID int,

CourseName varchar(1000),

Rating numeric(2,1)

)

Your team has a SQL Script that contains the following statements

CREATE TABLE Course

(

CourseID int,

CourseName varchar(1000),

Rating numeric(2,1)

)

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(1,'AZ-204 Developing Azure solutions',4.5)

SELECT * FROM Course

Which of the following statement types does the following statement come under?

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(1,'AZ-204 Developing Azure solutions',4.5)

Your team has a SQL Script that contains the following statements

CREATE TABLE Course

(

CourseID int,

CourseName varchar(1000),

Rating numeric(2,1)

)

INSERT INTO Course(CourseID,CourseName,Rating) VALUES(1,'AZ-204 Developing Azure solutions',4.5)

SELECT * FROM Course

Which of the following statement types does the following statement come under?

SELECT * FROM Course

Your team has an Azure SQL Database. They want to create several tables in the database. Which of the following can be used to help uniquely identify each row in a table?

Your team has an Azure SQL Database. They want to create several tables in the database. Which of the following can be used to create relationships between tables?

Your company is planning on making use of the various Platform as a service offering on Azure. Do companies have less to manage and maintain when it comes to Platform as a service offering when compared to Infrastructure as a service offering?

Your company is planning on making use of the various Platform as a service offering on Azure. Do IT administrators get full administrative privilege over the underlying service?

Your company is planning on setting up a set of databases based on the Azure SQL database service. The requirement is to ensure that the database support database size up to 100TB. Which of the following can be considered for this requirement?

Your company is planning on setting up a set of databases based on the Azure SQL database service. The requirement is to ensure that the database scales automatically based on demand and also automatically pauses the database during inactive periods. Which of the following can be considered for this requirement?

Your company is planning on setting up a set of databases based on the Azure SQL database service. The requirement is to ensure that a set of databases effectively use the same set of server resources. Which of the following can be considered for this requirement?

You have a table hosted in an Azure SQL database. The table contains the following information

You have to add a new row to the table. Which of the following would you use in the SQL statement for this requirement?

You have a table hosted in an Azure SQL database. The table contains the following information

You have to change the price of the row where the courseid is 3. Which of the following would you use in the SQL statement for this requirement?

You have a table hosted in an Azure SQL database. The table contains the following information

You have to remove the row from the table where the coursename is DP-203. Which of the following would you use in the SQL statement for this requirement?

Your company is currently using Azure Data Lake Gen2 as a data store. Here data is being streamed onto the data store via Azure Event Hubs. The data is then taken on a daily basis via Azure Data Factory. And Azure Data Factory sends the data onto a SQL data warehouse in Azure Synapse Analytics.

Here which tool can be used for the transformation of data?

What type of data analytics does the following come under?

“How much money have we made the prior month based on sales”

What type of data analytics does the following come under?

“What can be done to boost our sales in the coming”

What type of data analytics does the following come under?

“What will happen if we carry out a major sales campaign in the month of November”

Your team needs to set up a set of data stores. Below are the key requirements for each data store

Which of the following would you consider as the data store for Store1?

Your team needs to set up a set of data stores. Below are the key requirements for each data store

Which of the following would you consider as the data store for Store2?