ExamGecko
Home Home / Microsoft / DP-900

Microsoft DP-900 Practice Test - Questions Answers, Page 16

Question list
Search
Search

List of questions

Search

Related questions











Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

Which Azure service should you use?

A.
Azure HDInsight
A.
Azure HDInsight
Answers
B.
Azure SQL Database
B.
Azure SQL Database
Answers
C.
Azure Cosmos DB
C.
Azure Cosmos DB
Answers
D.
SQL Server on Azure virtual machines
D.
SQL Server on Azure virtual machines
Answers
Suggested answer: B

Explanation:

Section: Describe how to work with relational data on Azure

Reference: https://azure.microsoft.com/en-us/services/sql-database/#features

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

A.
Microsoft SQL Server Management Studio (SSMS)
A.
Microsoft SQL Server Management Studio (SSMS)
Answers
B.
Azure Data Studio
B.
Azure Data Studio
Answers
C.
Azure CLI
C.
Azure CLI
Answers
D.
Azure PowerShell
D.
Azure PowerShell
Answers
Suggested answer: B

Explanation:

Section: Describe how to work with relational data on Azure

Reference:

https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/

You have an e-commerce application that reads and writes data to an Azure SQL database.

Which type of processing does the application use?

A.
stream processing
A.
stream processing
Answers
B.
batch processing
B.
batch processing
Answers
C.
Online Analytical Processing (OLAP)
C.
Online Analytical Processing (OLAP)
Answers
D.
Online Transaction Processing (OLTP)
D.
Online Transaction Processing (OLTP)
Answers
Suggested answer: D

Explanation:

Section: Describe how to work with relational data on Azure

OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.

Reference:

https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/

When can you use an Azure Resource Manager template?

A.
to automate the creation of an interdependent group of Azure resources in a repeatable way
A.
to automate the creation of an interdependent group of Azure resources in a repeatable way
Answers
B.
to apply Azure policies for multi-tenant deployments
B.
to apply Azure policies for multi-tenant deployments
Answers
C.
to provision Azure subscriptions
C.
to provision Azure subscriptions
Answers
D.
to control which services and feature administrators and developers can deploy from the Azure portal
D.
to control which services and feature administrators and developers can deploy from the Azure portal
Answers
Suggested answer: A

Explanation:

Section: Describe how to work with relational data on Azure

You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed

To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.

Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

You have an Azure SQL database that you access directly from the Internet.

You recently changed the public IP address of your computer.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.

What is a possible cause of the issue?

A.
role-based access control (RBAC)
A.
role-based access control (RBAC)
Answers
B.
Dynamic Host Configuration Protocol (DHCP)
B.
Dynamic Host Configuration Protocol (DHCP)
Answers
C.
Domain Name Service (DNS)
C.
Domain Name Service (DNS)
Answers
D.
a database-level firewall
D.
a database-level firewall
Answers
Suggested answer: D

Explanation:

Section: Describe how to work with relational data on Azure

The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.

When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.

Reference:

https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A.
database
A.
database
Answers
B.
item
B.
item
Answers
C.
container
C.
container
Answers
D.
partition
D.
partition
Answers
Suggested answer: A, C

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A.
the throughput
A.
the throughput
Answers
B.
the read region
B.
the read region
Answers
C.
the partition key
C.
the partition key
Answers
D.
the API
D.
the API
Answers
Suggested answer: A, C

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

A.
graph
A.
graph
Answers
B.
key/value
B.
key/value
Answers
C.
object
C.
object
Answers
D.
columnar
D.
columnar
Answers
Suggested answer: D

Explanation:

Section: Describe how to work with non-relational data on Azure

Which storage solution supports role-based access control (RBAC) at the file and folder level?

A.
Azure Disk Storage
A.
Azure Disk Storage
Answers
B.
Azure Data Lake Storage
B.
Azure Data Lake Storage
Answers
C.
Azure Blob storage
C.
Azure Blob storage
Answers
D.
Azure Queue storage
D.
Azure Queue storage
Answers
Suggested answer: B

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

A.
Archive
A.
Archive
Answers
B.
Hot
B.
Hot
Answers
C.
Cool
C.
Cool
Answers
Suggested answer: A

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference:

https://cloud.netapp.com/blog/azure-blob-storage-pricing-the-complete-guide-azure-cvo-blg#H1_4

Total 285 questions
Go to page: of 29