Azure DP 900

Question 89: Which of the following is the right term for the following? "An object that is associated with a table that sorts and stores the data rows in the table based on their key values" • A clustered index • A FileTable • A foreign key • A stored procedure

A clustered index

Question 55: You have to develop a solution that needs to provide data to senior executives. Below are the key requirements a) The solution must provide an interactive graphic interface b) It must depict various key performance indicators c) It must support data exploration by using drill down Which of the following can be used within Microsoft BI for this requirement? • A dashboard Microsoft Power Apps A dataflow A report

A dashboard

Question 75: You created an Azure SQL database. You were accessing the database from your workstation from the Internet. Your workstation then changed its IP address and now you cannot access the database anymore. Which of the following could be the cause of the issue? A database-level firewall •Role-based access control (RSAC) •Dynamic Host Configuration Protocol (DHCP) •Domain Name Service (DNS)

A database-level firewall

Question 24: Which of the following is TRUE when it comes a key/value data store? A key value data store is optimized for enforcing constraints A key value data store is optimized for simple lookups A key value data store is optimized for table joins A key value data store is optimized for transactions

A key value data store is optimized for simple lookups Explanation: A key value store is better for simple lookups based on the key.

Question 57: You have to develop a reporting solution for your company. The solution needs to support paginated reports. The reports should be able to query a dimensional model in a data warehouse. Which of the following type of processing must the reporting solution use? A stream processing Online Transaction Processing (OLTP) Batch processing Online Analytical Processing (OLAP)

A stream processing Online Transaction Processing (OLTP) Batch processing Online Analytical Processing (OLAP)

Question 1: Which of the following is required for an extract, load and transform (ELT) process? A data pipeline that includes a transformation engine ​A separate transformation engine A target data store powerful enough to transform the data Data that is fully processed before being loaded to the target data store

A target data store powerful enough to transform the data Explanation: In the ELT process, the transformation happens on the target system. Hence the target system must be powerful enough to transform the data.

Question 60: Which of the following is correct when it comes to an extract, transform and load process? An extract , transform and load process requires a matching schema in the data source and the data target An extract , transform and load process requires a target data store powerful enough to transform the data An extract , transform and load process requires data that is fully processed before being loaded to the target data store An extract, transform and load process requires that the data target be a relational database.

An extract, transform and load process requires that the data target be a relational database.

Question 45: Which of the following is an Azure Data Factory component that provides the compute environment for activities? A linked service An integration runtime A control flow A pipeline

An integration runtime

Question 37: Your company need to store data in Azure Blob storage. The data needs to be stored for seven years. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which of the following is the ideal storage tier to use for this requirement? Archive Hot Cool

Archive

Question 98: You have to map the relevant security component to the appropriate scenario Which of the following would you map for the following scenario? "Support Azure Active Directory sign-ins to an Azure SQL database" Authentication • Firewall • Encryption

Authentication

Question 33: Which of the following is a feature in Azure Cosmos DB that provides redundancy within an Azure region? Multi-master replication Availability Zones Automatic failover The strong consistency level •

Availability Zones Explanation When creating a Cosmos DB, it will replicate automatically to multiple availability zones. If one zone goes down, you still have the other zones available. Option A is incorrect because this is an option when you enable writes onto multiple regions for Azure Cosmos DB. Option C is incorrect because automatic failover happens when data is replicated across multiple regions Option D is incorrect because consistency is an option for maintain the consistency of data when you have multiple regions enabled for your Azure Cosmos DB account.

Question 84: A set of developers have computers that run Windows 10 and Ubuntu Desktop. They need to connect and query an Azure SQL database from their computer. The developers require code assistance features such as IntelliSense. Which of the following can be used for this requirement? Azure Data Studio •Microsoft SQL Server Management Studio •Azure Data Explore

Azure Data Studio

Question 17: You have to write a set of queries that will help administrators to troubleshoot an Azure SQL database. You have to be able to embed the documents and query results into a SQL notebook. Which of the following would you use for this requirement? Microsoft SQL Server Management Studio (SSMS) Azure Data Studio Azure CLI Azure PowerShell

Azure Data Studio Explanation You can use SQL Notebooks in Azure Data Studio.

Question 38: Which of the following are two Azure services that can be used to provision Spark clusters? Azure Databricks Azure Log Analytics Azure Time Series Insights Azure HDInsight

Azure Databricks Azure HDInsight

Question 25: Your company has an application that runs on Windows. It needs access to a mapped drive. Which of the following is an Azure service you can use for this requirement? Azure Cosmos DB Azure Table storage Azure Files Azure Blob storage

Azure Files Explanation: Azure Files allows you to make use of mapped drives

Question 16: Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which of the following can be implemented for this requirement? Azure HDInsight Azure SQL Database Azure Cosmos DB SQL Server on Azure virtual machines

Azure SQL Database Explanation With the Azure SQL database, you don't need to maintain the underlying infrastructure.

Question 68: Which of the following is an Azure SQL database offering that supports automatic database scaling and automatic pausing of the database during inactive periods? Azure SQL Database Hyperscale Azure SQL managed instance Azure SQL Database serverless Azure SQL Database elastic pool

Azure SQL Database serverless

Question 2: A company is planning on implementing the following workloads. 1) Storage of data for a product catalog that will be loaded every 12 hours to a data warehouse 2) Storage of data for online purchases will be loaded to a data warehouse as the purchases occur 3) Updates to the inventory data that will be loaded to a data warehouse every 1000 transactions Which of the following is the workload type for the workload? "Storage of data for a product catalog that will be loaded every 12 hours to a data warehouse" Batch ​Micro-Batch Streaming

Batch

Question 63: Which of the following is TRUE when it comes to batch workloads? Batch workloads process data in memory, row-by-row Batch workloads collect and process data at most once a day Batch workloads process data as new data is received in real-time Batch workloads collect data and then process the data when a condition is met

Batch workloads process data in memory, row-by-row

Question 22: Which of the following would you map to the Graph data structure? Cassandra API Gremlin API MongoDB API Table API

Cassandra API Gremlin API MongoDB API Table API Explanation The Gremlin API supports the usage of graph database.

Question 9: Which of the following are two aspects of real-time data processing? Data is processed as it is created Low latency is expected High latency is expected Data is processed periodically

Data is processed as it is created Low latency is expected Explanation: Here data needs to be processed immediately. And here low latency is expected. You should be able to retrieve the data immediately so that it can be processed.

Question 39: You have to work with the Azure Data Factory service. You need to map the Azure Data Factory components to the right descriptions. Which of the following component should be mapped to the following description? " A representation of data structures within data stores" Dataset Linked service Mapping data flow Pipeline

Dataset

Question 6: You need to match the right type of analytics that can be used for the following business scenario? "Which people are mentioned in a company's business documents?" Cognitive • Descriptive • Diagnostics • Prescriptive • Predictive

Descriptive Descriptive Analytics - What or Who happened? Diagnostic Analytics - Why did it happen? Predictive Analytics - What will happen next? Prescriptive Analytics - What actions should we take?

Question 10: Which of the following is an example of an analytics bar chart that shows year-to-date sales by region? • descriptive • diagnostic • predictive • Prescriptive

Diagnostic Descriptive Analytics - What happened? Diagnostic Analytics - Why did it happen? Doesn't ask questions as to what's next simply a tool to show why Predictive Analytics - What will happen next? Prescriptive Analytics - What actions should we take?

Question 32: You have to state whether the following is TRUE or FALSE. "Items contained in the same Azure Cosmos DB logical partition can have different partition keys" TRUE FALSE

FALSE Explanation All items in the same logical partition must and will have the same partition key.

Question 30: You have to state whether the following is TRUE or FALSE. "The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account" TRUE FALSE

FALSE Explanation The Cosmos DB API is configured at the account level and not at the database level.

Question 23: You currently manage an application that stores data within a shared folder on a Windows server. You have to move the shared folder to Azure Storage. Which of the following service within an Azure storage account could you use for this purpose? Queue Blob File Table

File Explanation You can use the File service to create file shares. These file shares can be mounted on Windows Servers.

Question 12: A relational database is appropriate for which of the below scenarios? •For those scenarios where there is a high volume of changes to relationships between entities For those scenarios where there is a high volume of geographic distributed writes For those scenarios where there is a high volume of transactional writes For those scenarios where there is a high volume of writes that have varying data structures

For those scenarios where there is a high volume of transactional writes Explanation A relational database can be used for OLTP purposes. This is can be used for transactional systems. Hence if you have a high volume of transactional writes, you can make use of relational databases. Option A is incorrect because if you gave a lot of relationship changes, then it would be an additional headache for the data in the table to adhere to those relationship changes. Option B is incorrect because it becomes difficult to maintain the integrity of data if writes are happening from many locations. Option D is incorrect because if there are varying data structures, it becomes difficult for the data to adhere to those varying data structures.

Question 27: Your company needs to design a database that shows how traffic changes in one area of a network affect other components on the network. Which of the following is a data store type you would use for this requirement? Key/value Graph Document Columnar

Graph Explanation: It would be ideal to define the network as nodes in a graph-based database. You can define the relationship between the networks as edges between the nodes.

Question 65: Which of the following is an example of Data Manipulation Language (DML)? INSERT • DISABLE • ALTER • DROP

INSERT

Question 61: Which of the following is correct when it comes to batch processing? In batch processing , data is always inserted one row at a time In batch processing , data is processed in real-time In batch processing , latency is expected In batch processing , processing can only occur serially

In batch processing , latency is expected

Question 20: You have to map the right term to the term description. Which of the following would you map to the following description? " A database object that helps improve the speed of data retrieval" Index View Table

Index Explanation The index defined on the table can be used to improve the speed of data retrieval.

Question 40: Which of the following component should be mapped to the following description? "The information used to connect to external data sources" Dataset Linked service Mapping data flow Pipeline

Linked Service

Question 4: A company is planning on implementing the following workloads. 1) Storage of data for a product catalog that will be loaded every 12 hours to a data warehouse 2) Storage of data for online purchases will be loaded to a data warehouse as the purchases occur 3) Updates to the inventory data that will be loaded to a data warehouse every 1000 transactions Which of the following is the workload type for the workload? "Updates to the inventory data that will be loaded to a data warehouse every 1000 transactions" Batch ​Micro-Batch Streaming

Micro-Batch

Question 96: You have to design and model a database by using a graphical tool that supports object-oriented offline database development. Which of the following could you use for this requirement? Microsoft SQL Server Data Tools (SSDT) • Microsoft SQL Server Management Studio (SSMS) • Azure Databricks • Azure Data Studio

Microsoft SQL Server Data Tools (SSDT)

Question 80: Which of the following is a benefit of hosting a database on an Azure SQL Managed instance when compared to an Azure SQL database? Native support for cross-database queries and transactions •Built-in high availability •System-Initiated automatic backups •Support for encryption at rest

Native support for cross-database queries and

Question 28: Your company needs a non-relational data store that is optimized for storing and retrieving files, videos, audio streams and virtual disk images. The data store must be able to store data, metadata and a unique ID for each file. Which of the following is a data store type you would choose for this requirement? Document Key/value Object Columnar

Object Explanation: For this you can use an Object data store like Azure Blob Storage. Here you can have metadata for each object and also a unique URL.

Question 8: You have an application that performs reads and writes data to an Azure SQL Database. Which of the following is the type of processing that can be performed on the database? Stream processing Batch processing Online Analytical Processing (OLAP) Online Transaction Processing (OLTP)

Online Transaction Processing (OLTP) Explanation: Online Transaction Processing (OLTP) is performed on a relational database.

Question 41: Which of the following component should be mapped to the following description? " A logical grouping of activities that performs a unit of work and can be scheduled" Dataset Linked service Mapping data flow Pipeline

Pipeline

Question 56: Which of the following needs to be used to build a Microsoft Power BI paginated report? Power BI report Builder • Power BI Desktop • Charticulator • The Power BI service

Power BI report Builder

Question 29: Your company wants to have an Azure storage account in place. They want to ensure that the data is replicated in another Azure region automatically. Which of the following can be used as the replication strategy for the storage account? Choose 2 answers from the options given below Read-access geo-redundant storage (RA_GRS) Zone-redundant storage (ZRS) Geo-redundant storage (GRS) Locally-redundant storage (LRS)

Read-access geo-redundant storage (RA_GRS) Geo-redundant storage (GRS) Explanation For this you can make use of Read-access geo-redundant storage (RA_GRS) and Geo-redundant storage (GRS). This ensures that data is replicated to another region.

Question 13: Which of the following is the right option when it comes to relational data? • Relational data is stored in a file system as unstructured data Relational data is stored in a hierarchical folder structure Relational data is stored in a tabular form of rows and columns Relational data is stored in a comma-separated value file

Relational data is stored in a tabular form of rows and columns Explanation Relational data is normally stored in the form of tables. The tables consist of rows and columns of data.

Question 58: Which of the following are activities that are performed in the Microsoft Power BI service? Choose 2 answers from the options given below Report and dashboard creation Report sharing and distribution Data modeling Data acquisition and preparation

Report and dashboard creation Report sharing and distribution

Question 7: Which of the following are two uses of data visualization? Choose 2 answers from the options given •Represent trends and patterns over time. Communicate the significance of data. Implement machine learning to predict future values. Consistently implement business logic across reports

Represent trends and patterns over time. Communicate the significance of data. Explanation: With data visualization, you can see patterns and trends in your data over time. You can also communicate the significance of data to your stakeholders.

Question 62: Which of the following is an example of a streaming workload? Sending transactions that are older than a month to an archive Sending transactions daily from point of sale (POS) devices Sending telemetry data from edge devices Sending cloud infrastructure metadata every 30 minutes

Sending telemetry data from edge devices

Question 90: Which of the following is correct when it comes to a relational database? •A dynamic schema is required • Data will be stored as key/value pairs Storing large images and videos • Strong consistency guarantees are required

Strong consistency guarantees are required

Question 42: You have to state whether the following is TRUE or FALSE. "When data is ingested from Azure Data Lake Storage across Azure regions, then you will incur costs for bandwidth" TRUE FALSE

TRUE

Question 44: You have to state whether the following is TRUE or FALSE. "You can implement Azure Data Lake Storage by creating an Azure Storage account" • TRUE FALSE

TRUE

Question 46: You have to state whether the following is TRUE or FALSE. "Azure Databricks is an Apache Spark-based collaborative analytics platform" TRUE FALSE

TRUE

Question 47: You have to state whether the following is TRUE or FALSE. "Azure Data Factory orchestrates data Integration workflows" TRUE FALSE

TRUE

Question 50: You have to state whether the following is TRUE or FALSE. "Azure Databricks can consume data from an Azure SQL database" •

TRUE

Question 51: You have to state whether the following is TRUE or FALSE. "Azure Databricks can consume data from Azure Event Hubs" •

TRUE

Question 52: You have to state whether the following is TRUE or FALSE. "Azure Databricks can consume data from Azure Cosmos DB" •

TRUE

Question 73: You have to state whether the following is TRUE or FALSE. "If you have a platform as a service database in Azure, backups are performed automatically" •

TRUE

Question 77: You have to state whether the following is TRUE or FALSE. "Azure Data Studio can be used to query an Azure SQL Database from a device that runs macOS" •

TRUE

Question 78: You have to state whether the following is TRUE or FALSE. "Microsoft SQL Server Management Studio enables users to create and use SQL notebooks" •

TRUE

Question 79: You have to state whether the following is TRUE or FALSE. "Azure Data Studio can be used to restore a database" •

TRUE

Question 81: You have to state whether the following is TRUE or FALSE. "Azure SQL Managed Instance supports cross-database queries" •

TRUE

Question 82: You have to state whether the following is TRUE or FALSE. "Azure SQL Managed Instance supports user-created backups" •

TRUE

Question 83: You have to state whether the following is TRUE or FALSE. "Azure SQL Managed Instance can be restored to SQL Server on an Azure virtual machine" •

TRUE

Question 87: You have to state whether the following is TRUE or FALSE. "Normalizing a database reduces data redundancy" •

TRUE

Question 88: You have to state whether the following is TRUE or FALSE. "Normalizing improves data integrity" •

TRUE

Question 31: You have to state whether the following is TRUE or FALSE. "Partition keys are used in Azure Cosmos DB to optimize queries" TRUE FALSE

TRUE Explanation Yes, the data in an Azure Cosmos DB database is partitioned via the partition keys.

Question 18: You have to map the right term to the term description. Which of the following would you map to the following description? " A database object that holds data" Index View Table

Table Explanation The table is used to hold data

Question 48: Which of the following is the right statement when it comes to the massively parallel processing engine in Azure Synapse Analytics? • The massively parallel processing engine of Azure Synapse Analytics distributes processing across compute nodes The massively parallel processing engine of Azure Synapse Analytics distributes processing across control nodes The massively parallel processing engine of Azure Synapse Analytics redirects client connections across compute nodes The massively parallel processing engine of Azure Synapse Analytics redirects client connections across control nodes

The massively parallel processing engine of Azure Synapse Analytics distributes processing across compute nodes

Question 76: When you initially create an Azure SQL Database, which of the following can always be used to connect to the database? • The Azure Active director/ (Azure AD) account that created the database The Azure Active Directly Azure AD administrator account The sa account The server admin login account of the logical server

The server admin login account of the logical server

Question 15: Which of the following is the right use case for an Azure Resource Manager (ARM) template? To automate the creation of an interdependent group of Azure resources in a repeatable way To automate the creation of an interdependent resources that can be deployed from the Azure portal To provision Azure subscriptions and apply policies for multi-tenant deployments To set complex permissions automatically on existing objects in an Azure subscription

To automate the creation of an interdependent group of Azure resources in a repeatable way Explanation Azure Resource Manager templates can be used to deploy resources to Azure. You can reuse the same templates to deploy the same set of resources in a repeatable way.

Question 19: You have to map the right term to the term description. Which of the following would you map to the following description? " A database object whose content is defined by a query" Index View Table

View Explanation The View is defined by a query.

Question 26: Which of the following is TRUE when it comes a graph database in Azure Cosmos DB? You can query a graph database in Azure Cosmos DB as a JSON document by using a SQL-like language You can query a graph database in Azure Cosmos DB as a partitioned row store by using Cassandra Query language You can query a graph database in Azure Cosmos DB as a partitioned row store by using Language-Integrated Query You can query a graph database in Azure Cosmos DB as nodes and edges by using Gremlin language

You can query a graph database in Azure Cosmos DB as nodes and edges by using Gremlin language Explanation: The graph database is based on nodes and edges. And you can use the Gremlin API in Azure Cosmos DB to host a graph based database.

Question 14: Your company currently has a transactional application that stores data in an Azure SQL Managed instance. In which of the following circumstances would you need to implement a read-only database replica? You need to generate reports without affecting the transactional workload. You need to audit the transactional application. You need to implement high availability in the event of a regional outage You need to improve the recovery point objective (RPO).

You need to generate reports without affecting the transactional workload. Explanation A read-only instance can be used to reduce the workload on your OLTP database. You can generate reports from the read-only copy of the database.

Question 34: At which of the following level in Azure Cosmos DB can you configure multiple write regions and read regions? database partition collection account

account Explanation This is done at the account level.

Question 36: At which of the following levels can you set the throughput for an Azure Cosmos DB account? Choose 2 answers from the options given below container item database partition

container database

Question 35: Your company is planning on designing an application that will write a high volume of JSON data that will have an application-defined schema. Which of the following can you specify as the data store type for this requirement? key/value document graph columnar

document Explanation For this you can use a document-based data store. Here the JSON data can be stored as documents.

Question 21: Which of the following is a command line tool that can be used to query Azure SQL databases? sqlcmd bcp azdata Azure CLI

sqlcmd bcp azdata Azure CLI Explanation The sqlcmd tool can be used to query Azure SQL databases.

Question 66: You have designed a SQL query that combines the customer data and the order data. The query includes calculated columns. You have to persist the SQL query so that other users can use the query. Which of the following should you create for this requirement? • A table • An index • Scalar function • A view

• A view

Question 69: Which of the following are benefits of using the Azure SQL Database service? Choose 2 answers from the options given below Complete control over backup and restore processes • Access to the latest features • In-database machine learning services • Reduced administrative effort for managing the server infrastructure

• Access to the latest features • Reduced administrative effort for managing the server infrastructure

Question 94: You have to ensure that users use multi-factor authentication when connecting to an Azure SQL Database. Which type of authentication would you implement for this requirement? • Service principal authentication • Azure Active Directory (Azure AD) authentication • SQL authentication • Certificate authentication

• Azure Active Directory (Azure AD) authentication

Question 49: Which of the following is an Azure storage solution that provides native support for POSIX-compliant access control lists? Azure Queue storage • Azure Data Lake Storage • Azure table storage • Azure Files

• Azure Data Lake Storage

Question 53: Which storage solution supports role-based access control (RBAC) at the file and folder level? • Azure Disk Storage • Azure Data Lake Storage • Azure Blob storage • Azure Queue storage

• Azure Data Lake Storage

Question 70: A company needs to ensure that an application hosted on an Azure virtual machine can connect to the Azure SQL Database without the need to expose the database to internet. Which of the following can be used for this requirement? • Azure DNS • Azure Application Gateway • Azure Private link • Azure Traffic Manager

• Azure Private link

Question 71: You have to deploy a data store for an application. The data store needs to be a relational database that supports Online Transaction Processing (OLTP). Which of the following can be used for this requirement? • Azure Cosmos DB • Azure Synapse Analytics • Azure SQL Database

• Azure SQL Database

Question 95: Which of the following statement is correct about Azure SQL database? By default, each Azure SQL database is protected by a network security group •By default, each Azure SQL database is protected by a server level firewall •By default, each Azure SQL database is protected by Azure Firewall •By default, each Azure SQL database is protected by Azure Front Door

• By default, each Azure SQL database is protected by a server level firewall

Question 93: Which statement is an example of Data Definition Language (DDL)? • SELECT • JOIN • MERGE • CREATE

• CREATE

Question 59: Which of the following is correct when it comes to Descriptive Analytics? Descriptive Analytics tells you what is most likely to occur in the future •Descriptive Analytics tells you what occurred in the past •Descriptive Analytics tells you which actions you can perform to affect outcomes •Descriptive Analytics tells you why something occurred in the past

• Descriptive Analytics tells you what occurred in the past

Question 99: You have to map the relevant security component to the appropriate scenario Which of the following would you map for the following scenario? "Ensure that sensitive data never appears as plain test in an Azure SQL database" • Authentication • Firewall • Encryption

• Encryption

Question 72: You have to state whether the following is TRUE or FALSE. "If you have a platform as a service database in Azure, you are responsible for applying the operating system updates" •

• FALSE

Question 74: You have to state whether the following is TRUE or FALSE. "If you have a platform as a service database in Azure, you are responsible for upgrading the database engine" •

• FALSE

Question 86: You have to state whether the following is TRUE or FALSE. "Normalization involves eliminating relationships between database tables" •

• FALSE

Question 97: You have to map the relevant security component to the appropriate scenario Which of the following would you map for the following scenario? "Prevent access to an Azure SQL database from another network" Authentication • Firewall • Encryption

• Firewall

Question 67: Which of the following is used by Relational databases to enforce relationships between different tables? Collections • Columns • Keys • Partitions

• Keys

Question 11: You need to match the right type of analytics that can be used for the following business scenario? "How do I allocate my budget to buy different inventory items" Cognitive • Descriptive • Diagnostics • Predictive • Prescriptive •

• Prescriptive Descriptive Analytics - What happened? Diagnostic Analytics - Why did it happen? Predictive Analytics - What will happen next? Prescriptive Analytics - What actions should we take? Explanation This should fall under prescriptive analysis. Here you want to know how to approach to fulfil a target requirement based on the data that is available.

Question 3: A company is planning on implementing the following workloads. 1) Storage of data for a product catalog that will be loaded every 12 hours to a data warehouse 2) Storage of data for online purchases will be loaded to a data warehouse as the purchases occur 3) Updates to the inventory data that will be loaded to a data warehouse every 1000 transactions Which of the following is the workload type for the workload? "Storage of data for online purchases will be loaded to a data warehouse as the purchases occur" Batch ​Micro-Batch Streaming

• Streaming

Question 43: You have to state whether the following is TRUE or FALSE. "You can use the blob, table and file storage service in the same Azure Storage account" • TRUE • FALSE

• TRUE

Question 85: Which of the following is correct when it comes to Transparent Data Encryption? • Transparent Data Encryption encrypts a column to protect data at rest and in transit •Transparent Data Encryption encrypts queries and their results in order to protect data in transit •Transparent Data Encryption encrypts the database to protect data at rest •Transparent Data Encryption encrypts the server to protect data at rest

• Transparent Data Encryption encrypts the database to protect data at rest

Question 91: You have an Azure SQL Database. You need to query a table named Products. Which of the following are requirements that need to be fulfilled to access the table? Choose 3 answers from the options given below • You must be assigned the Reader role for the resource group that contains the database. You must have SELECT access to the Products table. You must have a user in the database. You must be assigned the Contributor role for the resource group that contains the database. Your IP address must be allowed to connect to the database.

• You must have SELECT access to the Products table. • You must have a user in the database. • Your IP address must be allowed to connect to the database.

Question 54: Which of the following statement is right when it comes to Microsoft Power BI? • A Microsoft Power BI dashboard enables users to create highly formatted, fixed layout documents • A Microsoft Power BI interactive report enables users to create highly formatted, fixed layout documents • A Microsoft Power BI paginated report enables users to create highly formatted, fixed layout documents

•A Microsoft Power BI paginated report enables users to create highly formatted, fixed layout documents

Question 5: You need to match the right type of analytics that can be used for the following business scenario? "Why did the sales increase last month" • Cognitive • Descriptive • Diagnostics • Predictive • Prescriptive

•Diagnostic Analytics Descriptive Analytics - What happened? Diagnostic Analytics - Why did it happen? Predictive Analytics - What will happen next? Prescriptive Analytics - What actions should we take?

Question 92: Which of the following would you use for the following requirement? "A graphical tool for managing Azure SQL databases and viewing SQL execution plans" Azure Data Studio • Microsoft SQL Server Data Tools • Microsoft SQL Server Management Studio • Microsoft Visual Studio Code

•Microsoft SQL Server Management Studio