kelas A

How is data in a relational table organized?

• a. Rows and Columns

• b. Header and Footer

• c. Pages and Paragraphs

Which of the following is an example of unstructured data?

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

• b. Audio and Video files

• c. A table within SQL Server database

What of the following is an example of a streaming dataset

• a. Data from sensor feeds

• b. Sales data for the past month

• c. List of employees working for a company

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

• a. Backing up and restoring databases

• b. Creating dashboards and reports

• c. Identifying data quality issues

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

• a. SQL Server Management Studio

• b. Power BI

• c. SQL

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

• a. Systems Administrator

• b. Data Analyst

• c. Database Administrator

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

• a. All data must be stored as character strings

• b. A row in a table represents a single entity

• c. Different rows in the same table can contain different columns

What is an index?

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

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

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

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

• a. Azure Cosmos DB

• b. Azure SQL Database

• c. The Gremlin API

Which of the following is a characteristic of non-relational databases?

• a. Non-relational databases contain tables with flat fixed-column records

• b. Non-relational databases require you to use data normalization techniques to reduce data duplication

• c. Non-relational databases are either schema free or have relaxed schemas