A Review Of Vivid DP-900 Free Practice Test

NEW QUESTION 1
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

• A. document
• B. columnar
• C. graph
• D. time series

Answer: A

NEW QUESTION 2
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

NEW QUESTION 3
Which command-line tool can you use to query Azure SQL databases?

• A. sqlcmd
• B. bcp
• C. azdata
• D. Azure CLI

Answer: D

NEW QUESTION 4
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be
used once, more than once, or not at all. NOTE: Each correct match is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 5
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.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 6
You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

• A. INSERT
• B. MERGE
• C. UPDATE
• D. CREATE

Answer: C

NEW QUESTION 7
You have the following SQL query.

NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 8
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

NEW QUESTION 9
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 10
For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 11
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 12
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

NEW QUESTION 13
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

• A. Online Transaction Processing (OLTP)
• B. batch processing
• C. Online Analytical Processing (OLAP)
• D. stream processing

Answer: A

NEW QUESTION 14
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 15
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

• A. report and dashboard creation
• B. report sharing and distribution
• C. data modeling
• D. data acquisition and preparation

Answer: AD

NEW QUESTION 16
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?

• A. Microsoft SQL Server Data Tools (SSDT)
• B. Microsoft SQL Server Management Studio (SSMS)
• C. Azure Databricks
• D. Azure Data Studio

Answer: A

NEW QUESTION 17
To complete the sentence, select the appropriate option in the answer area.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 18
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

NEW QUESTION 19
Which scenario is an example of a streaming workload?

• A. sending transactions that are older than a month to an archive
• B. sending transactions daily from point of sale (POS) devices
• C. sending telemetry data from edge devices
• D. sending cloud infrastructure metadata every 30 minutes

Answer: C

NEW QUESTION 20
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 21
......