ExamGecko
Home Home / Microsoft / DP-900

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

Question list
Search
Search

Related questions











Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL

Server instances, while providing automated updates, backups, and maintenance tasks?

A.
Azure SQL Managed Instance
A.
Azure SQL Managed Instance
Answers
B.
SQL Server on Azure Virtual Machines
B.
SQL Server on Azure Virtual Machines
Answers
C.
Azure SQL Edge
C.
Azure SQL Edge
Answers
D.
Azure SQL Database
D.
Azure SQL Database
Answers
Suggested answer: A

A data engineer is responsible for which task?

A.
Design and build analytical models.
A.
Design and build analytical models.
Answers
B.
Design and implement data stores for analytical workloads.
B.
Design and implement data stores for analytical workloads.
Answers
C.
Explore data to identify trends.
C.
Explore data to identify trends.
Answers
D.
Implement policies, tools. and processes for backup and recovery plans.
D.
Implement policies, tools. and processes for backup and recovery plans.
Answers
Suggested answer: D

Which type of database contains nodes and edges?

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

What is a characteristic of non-relational data?

A.
a well-defined schema
A.
a well-defined schema
Answers
B.
no indexes
B.
no indexes
Answers
C.
self-describing entities
C.
self-describing entities
Answers
D.
no unique key values
D.
no unique key values
Answers
Suggested answer: D

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

A.
WHERE
A.
WHERE
Answers
B.
SELECT
B.
SELECT
Answers
C.
JOIN
C.
JOIN
Answers
Suggested answer: B

You have the following two tables of customer data.

Which type of data do the tables contain?

A.
non-relational
A.
non-relational
Answers
B.
structured
B.
structured
Answers
C.
semi-structured
C.
semi-structured
Answers
D.
unstructured
D.
unstructured
Answers
Suggested answer: D

Which file format has defined names and data types for each column and uses compressed columnar storage?

A.
JSON
A.
JSON
Answers
B.
CSV
B.
CSV
Answers
C.
Apache Parquet
C.
Apache Parquet
Answers
D.
HTML
D.
HTML
Answers
Suggested answer: C

You have structured data in tabular format.

What represents an individual instance of a data entity?

A.
a column
A.
a column
Answers
B.
a cell
B.
a cell
Answers
C.
a row
C.
a row
Answers
D.
a table
D.
a table
Answers
Suggested answer: C

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

A.
a timestamp
A.
a timestamp
Answers
B.
a range
B.
a range
Answers
C.
a row key
C.
a row key
Answers
D.
a partition key
D.
a partition key
Answers
Suggested answer: C, D

What is a difference between structured data and semi-structured data?

A.
Structured data has a fixed schema and semi-structured data has a flexible schema.
A.
Structured data has a fixed schema and semi-structured data has a flexible schema.
Answers
B.
Only Structured data supports entities.
B.
Only Structured data supports entities.
Answers
C.
Structured data has a flexible schema and semi-structured data has a fixed schema.
C.
Structured data has a flexible schema and semi-structured data has a fixed schema.
Answers
D.
Only Structured data supports attributes.
D.
Only Structured data supports attributes.
Answers
Suggested answer: A
Total 285 questions
Go to page: of 29