DP-900 Exam Dumps, DP-900 Exam Questions, DP-900 PDF Dumps, DP-900 VCE Dumps, Microsoft Exam

[February-2021]Latest Braindump2go DP-900 PDF Dumps and DP-900 VCE Dumps[Q95-Q120]

2021/February Latest Braindump2go DP-900 Exam Dumps with PDF and VCE Free Updated Today! Following are some new DP-900 Real Exam Questions!

QUESTION 95
A bar chart showing year-to date sales by region is an example of which type of analytics?

A. descriptive
B. diagnostic
C. predictive
D. prescriptive

Answer: B

QUESTION 96
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
clip_image002_thumb
Which type of analysis is shown for the fourth quarter?

A. predictive
B. prescription
C. descriptive
D. diagnostic

Answer: B

QUESTION 97
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage

Answer: A
Explanation:
Azure Files is Microsoft’s easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.
To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.
Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

QUESTION 98
What are two uses of data visualization? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

A. Represent trends and patterns over time.
B. Communicate the significance of data.
C. implement machine learning to predict future values.
D. Consistently implement business logic across reports

Answer: AC

QUESTION 99
What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

A. Data is processed as it is created.
B. Low latency is expected
C. High latency acceptable
D. Data is processed periodically

Answer: BD

QUESTION 100
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

A. Azure Queue storage
B. Azure Data Lake Storage
C. Azure table storage
D. Azure Files

Answer: C

QUESTION 101
You have an application that runs on Windows and requires across to a mapped drive.
Which Azure service should you use?

A. Azure Cosmos DB
B. Azure Table storage
C. Azure Files
D. Azure Blob Storage

Answer: A

QUESTION 102
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?

A. Key/value
B. Graph
C. Document
D. columnar

Answer: B

QUESTION 103
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

A. document
B. key/value
C. object
D. columnar

Answer: C
Explanation:
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store- overview

QUESTION 104
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.

A. read-access geo-redundant storage (RA_GRS)
B. zone-redundant storage (ZRS)
C. geo-redundant storage (GRS)
D. locally-redundant storage (LRS)

Answer: AC
Explanation:
Azure Storage offers two options for copying your data to a secondary region:
Geo-redundant storage (GRS)
Geo-zone-redundant storage (GZRS)
With GRS or GZRS, the data in the secondary region isn’t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read access geo-zone- redundant storage (RA-GZRS).
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

QUESTION 105
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
B. to automate the creation of an interdependent and develop can deploy from the Azure portal
C. To provision Azure subscriptions and apply policies for multi-tenant deployments
D. To set complex permissions automatically on existing objects in an Azure subscription

Answer: A
Explanation:
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

QUESTION 106
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

A. multi-master replication
B. Availability Zones
C. automatic failover
D. the strong consistency level

Answer: B

QUESTION 107
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

A. database
B. partition
C. collection
D. account

Answer: C

QUESTION 108
Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

A. key/value
B. document
C. graph
D. columnar

Answer: A
Explanation:
A key/value store associates each data value with a unique key. An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data store-overview

QUESTION 109
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends.
Which type of data store should you use?

A. relational
B. columnar
C. graph
D. time series

Answer: D
Explanation:
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

QUESTION 110
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

A. supports partitioning
B. provides resiliency if art Azure region fads
C. provides a higher storage capacity
D. supports a multi-master model

Answer: B

QUESTION 111
Which setting can only be configured during the creation of an Azure Cosmos DB account?

A. geo-redundancy
B. multi-region writes
C. production or non-reduction account type
D. API

Answer: C

QUESTION 112
Which statement is an example of Data Manipulation Language (DML).

A. INSERT
B. DISABLE
C. ALTER
D. DROP

Answer: A
Explanation:
Data Manipulation Language (DML) statements:
DELETE
INSERT
UPDATE
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

QUESTION 113
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?

A. a table
B. an index
C. scalar function
D. a view

Answer: B

QUESTION 114
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

A. Azure SQL Database Hyperscale
B. Azure SQL managed instance
C. Azure SQL Database serveless
D. Azure SQL Database elastic pod

Answer: B

QUESTION 115
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. complete control over backup and restore processes
B. access to the latest features
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure

Answer: BC

QUESTION 116
Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

A. Azure DNS
B. Azure Application Gateway
C. Azure Private link
D. Azure Traffic Manager

Answer: B

QUESTION 117
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure serv ce should you use to support the application?

A. Azure Cosmos D3
B. Azure Synapse Analytics
C. Azure HCMmtghi
D. Azure SQL Database

Answer: B

QUESTION 118
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
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. a database-level firewall
B. role-based access control (RSAC)
C. Dynamic Host Configuration Protocol (DHCP)
D. Domain Name Service (DNS)

Answer: A
Explanation:
The Azure SQL Database firewall lets you decide w ic 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/config ring-the-azure-sql-database-firewall/

QUESTION 119
When you create an Azure SQL database, which account can always connect to the database ?

A. the Azure Active director/ (Azure AO) account that created the database
B. the Azure Active Directly Azure AD) administrator account
C. the sa account
D. the server admin login account of the logical server

Answer: B

QUESTION 120
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?

A. Azure Data Studio
B. sq1cmd
C. Microsoft SQL Server Management Studio (SSMS)
D. Azure Data Explorer

Answer: B


Resources From:

1.2021 Latest Braindump2go DP-900 Exam Dumps (PDF & VCE) Free Share:
https://www.braindump2go.com/dp-900.html

2.2021 Latest Braindump2go DP-900 PDF and DP-900 VCE Dumps Free Share:
https://drive.google.com/drive/folders/1L1Swg242dV2heEY8KHLG49Z8Cd0UEiQa?usp=sharing

3.2020 Free Braindump2go DP-900 Exam Questions Download:
https://www.braindump2go.com/free-online-pdf/DP-900-PDF-Dumps(126-143).pdf
https://www.braindump2go.com/free-online-pdf/DP-900-Dumps(111-125).pdf
https://www.braindump2go.com/free-online-pdf/DP-900-VCE-Dumps(95-110).pdf

Free Resources from Braindump2go,We Devoted to Helping You 100% Pass All Exams!