ExamGecko
Home Home / Microsoft / DP-900

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

Question list
Search
Search

Related questions











Which language is used to define queries in Azure Synapse Data Explorer?

A.
Bash
A.
Bash
Answers
B.
PowerShell
B.
PowerShell
Answers
C.
KQL
C.
KQL
Answers
D.
SQL
D.
SQL
Answers
Suggested answer: C

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A.
an Azure SQL Database elastic pool
A.
an Azure SQL Database elastic pool
Answers
B.
Azure SQL Managed Instance
B.
Azure SQL Managed Instance
Answers
C.
Azure Database for MySQL
C.
Azure Database for MySQL
Answers
D.
Azure SQL Database
D.
Azure SQL Database
Answers
Suggested answer: B

What can be used with native notebook support to query and visualize data by using a web-based interface?

A.
Azure Databricks
A.
Azure Databricks
Answers
B.
pgAdmin
B.
pgAdmin
Answers
C.
Microsoft Power Bl
C.
Microsoft Power Bl
Answers
Suggested answer: A

Explanation:

You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

A.
object data
A.
object data
Answers
B.
graph
B.
graph
Answers
C.
key/value
C.
key/value
Answers
D.
time series
D.
time series
Answers
Suggested answer: B

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

A.
bridge
A.
bridge
Answers
B.
dimension
B.
dimension
Answers
C.
fact
C.
fact
Answers
Suggested answer: C

Which Azure Cosmos DB API should you use for a graph database?

A.
Azure Cosmos DB for Apache Gremlin
A.
Azure Cosmos DB for Apache Gremlin
Answers
B.
Azure Cosmos DB for NoSQL
B.
Azure Cosmos DB for NoSQL
Answers
C.
Azure Cosmos DB for Apache Cassandra
C.
Azure Cosmos DB for Apache Cassandra
Answers
D.
Azure Cosmos DB for Table
D.
Azure Cosmos DB for Table
Answers
Suggested answer: A

In a fully denormalized database, how is data read and written for a single entity?

A.
Data is read from a single table and written to a single table.
A.
Data is read from a single table and written to a single table.
Answers
B.
Data is read from multiple tables and written to a single table.
B.
Data is read from multiple tables and written to a single table.
Answers
C.
Data is read from a single table and written to multiple tables.
C.
Data is read from a single table and written to multiple tables.
Answers
D.
Data is read from multiple tables and written to multiple tables.
D.
Data is read from multiple tables and written to multiple tables.
Answers
Suggested answer: B

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

A.
a scalar function
A.
a scalar function
Answers
B.
a table
B.
a table
Answers
C.
an index
C.
an index
Answers
D.
a view
D.
a view
Answers
Suggested answer: D

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

A.
extract transform, and load (ETL)
A.
extract transform, and load (ETL)
Answers
B.
a data warehouse
B.
a data warehouse
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

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

A.
Data Definition Language (DDL)
A.
Data Definition Language (DDL)
Answers
B.
Data Control Language (DCL)
B.
Data Control Language (DCL)
Answers
C.
Data Manipulation Language (DML)
C.
Data Manipulation Language (DML)
Answers
Suggested answer: C
Total 285 questions
Go to page: of 29