D900_1

How is data in a relational table organized?

• Rows and Columns

• Header and Footer

• Pages and Paragraphs

Which of the following is an example of unstructured data?

• An Employee table with columns Employee ID, Employee Name, and Employee Designation

• Audio and Video files

• A table within SQL Server database

What of the following is an example of a streaming dataset?

• Data from sensors and devices

• Sales data for the past month

• List of employees working for a company

Which one of the following tasks is a role of a database administrator?

• Backing up and restoring databases

• Creating dashboards and reports

• Identifying data quality issues

Which of the following tools is a visualization and reporting tool?

• ​SQL Server Management Studio

• Power BI

• SQL

Which one of the following roles is not a data job role?

• Systems Administrator

• Data Analyst

• ​Database Administrator

Which one of the following statements is a characteristic of a relational database?

• ​All data must be stored as character strings

• ​A row in a table represents a single entity

• ​Different rows in the same table can contain different columns

What is an index?

• ​A structure that enables you to locate rows in a table quickly, using an indexed value

• ​A virtual table based on the result set of a query

• ​A structure comprising rows and columns that you use for storing data

Which one of the following statements is a benefit of using a PaaS service, instead of an on-premises system, to run your database management systems?

• ​Increased day-to-day management costs

• ​Increased scalability

• ​Increased functionality

Which of the following services should you use to implement a non-relational database?

• ​Azure Cosmos DB

• Azure SQL Database

• ​The Gremlin API