Valid DP-900 Test Answers & Microsoft DP-900 Exam PDF
Microsoft DP-900 Certification Real 2022 Mock Exam
NEW QUESTION 57
You have a SQL query that combines customer data and order dat
a. 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. scalar function
- C. a view
- D. an index
Answer: D
NEW QUESTION 58
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
NEW QUESTION 59
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
- A. Azure Active Directory (Azure AD) authentication
- B. certificate authentication
- C. SQL authentication
- D. service principal authentication
Answer: A
NEW QUESTION 60
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. Online Analytical Processing (OLAP)
- B. stream processing
- C. batch processing
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
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/
NEW QUESTION 61
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
- A. Microsoft Power Apps
- B. a dataflow
- C. a dashboard
- D. a report
Answer: D
NEW QUESTION 62
Which statement is an example of Data Manipulation Language (DML)?
- A. CREATE
- B. DISABLE
- C. UPDATE
- D. REVOKE
Answer: C
Explanation:
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
NEW QUESTION 63
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 64
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
NEW QUESTION 65
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described
https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15
NEW QUESTION 66
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 67
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. zone-redundant storage (ZRS)
- B. locally-redundant storage (LRS)
- C. read-access geo-redundant storage (RA_GRS)
- D. geo-redundant storage (GRS)
Answer: C,D
Explanation:
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).
NEW QUESTION 68
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Like IaaS, PaaS includes infrastructure - servers, storage, and networking - but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service provider typically manages everything else.
Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
NEW QUESTION 69
What should you use to build a Microsoft Power BI paginated report?
- A. Charticulator
- B. Power BI Desktop
- C. Power BI report Builder
- D. the Power BI service
Answer: C
Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw
NEW QUESTION 70
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. graph
- B. columnar
- C. key/value
- D. document
Answer: C
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
NEW QUESTION 71
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 72
When can you use an Azure Resource Manager template?
- A. to automate the creation of an interdependent and develop can deploy from the Azure portal
- B. to automate the creation of an interdependent group of Azure resources in a repeatable way
- C. To set complex permissions automatically on existing objects in an Azure subscription
- D. To provision Azure subscriptions and apply policies for multi-tenant deployments
Answer: D
NEW QUESTION 73
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench
NEW QUESTION 74
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 75
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions
NEW QUESTION 76
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. columnar
- B. Document
- C. Graph
- D. Key/value
Answer: C
NEW QUESTION 77
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
NEW QUESTION 78
......
DP-900 Exam Questions and Valid DP-900 Dumps PDF: https://surepass.actualtests4sure.com/DP-900-practice-quiz.html
