What are the primary features of a NoSQL database? (Select TWO.)

NoSQL databases use data models that are not based on relational tables

NoSQL databases have a flexible schema.

NoSQL databases work well for customer relation management (CRM) applications or enterprise resource planning (ERP) applications.

NoSQL databases use vertical scaling.

NoSQL databases can run transactional or analytical queries.

A centralized repository that can store structured and unstructured data

A database that does not use a table structure to store data

A database that uses a table structure to store data

A type of software that provides database functionality

What is the primary benefit of using databases-as-a-service (DBaaS)?

They reduce the cost of installing and maintaining the servers.

They are only used for processing small datasets.

They increase the cost of installing and maintaining the servers.

They can be modified so administrators can perform management tasks,such as server provisioning, patching, setup, configuration, backups, or recovery.

What is the purpose of data definition language (DDL) statements in structured query language (SQL)?

They are used to create and modify the structure of a database.

They are used to view, change, and manipulate data in a table.

They are used to control access to the data in a database.

They are used to perform queries on the data in schema objects.

What is the function of the SELECT statement in structured query language (SQL)?

Add or delete columns in a table

Which statement describes a foreign key?It is a reference to a column in another table. Words that SQL reserves and have predefined data types. It is a purposeful way to name objects or items in a database. It enforces limits on the types of data that can go in a table.

It is a reference to a column in another table.

Words that SQL reserves and have predefined data types.

It is a purposeful way to name objects or items in a database.

It enforces limits on the types of data that can go in a table.

Which statement defines referential integrity?

Foreign key values must match an existing primary key value.

The primary key value matches an existing foreign key.

Rules and limitations are imposed by the database management system (DBMS).

Columns automatically have foreign key and primary key constraints.

What is the purpose of data manipulation language (DML) statements in structured query language (SQL)?

They are used to view, add, change, or delete data in a table.

They control access to the data in a database

They perform queries on the data within schema objects.

They create and modify the structure of a database.

What is the function of the statement in structured query language (SQL)?

It is used to update existing records in a table.

It is used to create and modify the structure of a database.

It is used to delete records in an existing table.

It is used to remove a table definition and all the table data.

What is the function of a NULL value in structured query language (SQL)?

It is used to represent a missing value.

It is used to provide a description of the specified table or view.

It is a NULL value that represents a boolean value.

It is a constraint that enforce a column to not accept NULL values.

How is a comma-separated values (CSV) file validated before it is imported into a database?

Confirm that the structure of the data in the file matches the number of columns in the table and the type of data in each column.

Confirm that each piece of information in the file is placed in a new row.

Confirm that values are enclosed with single quotation marks (‘ ‘) for character values or date values.

Verify that the information in the file is formatted in several columns.

Change every character in a string to lowercase.

What is the purpose of the CONCAT function in structured query language (SQL)?

It combines strings from several columns and puts them together in one line.

It returns the number of rows in a table.

It removes characters from the beginning and end of a string.

It creates a substring with a specified length.

Which statement describes the purpose of a WHERE clause in a SELECT statement?

The WHERE clause requests only specific rows from a table.

The WHERE clause uses a column identifier to organize the result-set data into groups.

The WHERE clause sorts query results by one or more columns in either ascending or descending order.

The WHERE clause provides an alias for each column or expression.

What is the purpose of using aliases in structured query language (SQL) statements?

Aliases create temporary names for columns.

Aliases create temporary names for constraints.

Aliases create temporary names for rows.

Aliases create temporary names for queries.

Which SELECT statement displays only the unique combinations of values of custname and custnum?

SELECT DISTINCT custname, custnum FROM customers;

SELECT UNIQUE custname, custnum FROM customers;

SELECT ORDER BY custname, custnum FROM customers;

SELECT DIFFERENCE custname, custnum FROM customers;

What is the purpose of the SUBSTRING function?

It returns a specific portion of the string.

It removes leading spaces and trailing spaces from a string.

It adds two or more expressions together.

It finds the minimum value in a set of values.

A database administrator must use a structured query language (SQL) query to rank book reviews. The data is in the codebook_reviews book_reviews* column in the customers table. The query must skip ranking positions if a row has the same rank as another row. The query must then output the reviews by ascending order. Which SQL statement should the administrator use?

RANK() OVER (ORDER BY book_reviews ASC) AS 'RANK', FROM customers;

RANK() OVER (GROUP BY book_reviews DESC) AS ‘RANK’, FROM customers;

RANK() OVER (ORDER BY book_reviews DESC) AS ‘RANK’, FROM customers;

RANK() OVER (GROUP BY book_reviews ASC) AS ‘RANK’, FROM customers;

Which option must be specified first when creating a database (DB) instance in Amazon Relational Database Service (Amazon RDS)?

Choose a DB instance identifier

Choose an Amazon Web Services (AWS)

Region Connect to the DB instance

Which task is considered to be a best practice for high availability in an Amazon Relational Database Service (Amazon RDS) database (DB) instance?

Deploying the DB instance in multiple Availability Zones (multi-AZ deployment)

Replicating the data six ways across three Availability Zones

Deploying the DB instance in a single Availability Zone (single-AZ deployment)

Creating a deployment within the same AWS Region

Which use case represents a reason for using Amazon Relational Database Service (Amazon RDS) instead of other database solutions?

Complex transactions or complex queries

Simple GET or PUT requests and queries

Relational database management system (RDBMS) customization

Support for key-value and document data models

What is the primary benefit of Amazon Relational Database Service (Amazon RDS)?

It can elastically scale out beyond the capacity constraints of a single database (DB) instance.

It supports Amazon Aurora, MySQL, MariaDB, Oracle, SQL Server, and PostgreSQL database engines.

It manages the work that is involved in setting up a relational database.

It runs a fully featured relational database while offloading database administration.

database aws

Authored by KEMAL -

Computers

University

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

A customer is ordering a product from an online retailer. If the payment for the transaction is successful, the Orders table must be updated so that a new order row is inserted. The stockTable table must also be updated so that product rows are removed for the purchased products. If one step fails, then all steps fail.
Which type of database transaction property does this scenario represent?

Atomicity

Consistency

Isolation

Durability

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Which type of database is Amazon DynamoDB?

Centralized database

NoSQL database

Relational database

Personal database

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

How does Amazon DynamoDB achieve high availability and scalability across Regions?

By using a collection of multiple replica tables

By using a collection of multiple items

By using a collection of multiple partition keys

By using a collection of one or more attributes

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Which statement describes the concept of partitioning in Amazon DynamoDB?

Partitioning is the allocation of storage for a table.

Partitioning is used to locate items in a table.

Partitioning is the manual replication of table across multiple Availability Zones within an AWS Region.

As data grows, table data is partitioned and indexed by a composite key.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Which statement about Amazon DynamoDB partition keys is true?

Partition keys uniquely identify each item in the table.

No two items in a table can use the same partition keys.

A table can have two partition keys.

A primary key is composed of two partition keys

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

How many ways can Amazon DynamoDB retrieve data from a DynamoDB table?

Four ways

Two ways

One way

Three ways

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

What is a database?

A collection of data that is organized into files called columns

A collection of data that is organized into files called rows

A collection of data that is organized into tables

A collection of data that organized into files called datasets.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

45 questions

Linux Questions

Quiz

•

University

51 questions

Module 11

Quiz

•

University

50 questions

UNIT-II - BASICS OF VIRTUALIZATION

Quiz

•

University

50 questions

Kuis tentang Kecerdasan Buatan

Quiz

•

10th Grade - University

45 questions

IP MIDTERM

Quiz

•

University

47 questions

Relational Database Design

Quiz

•

University

51 questions

Técnicas y herramientas para la obtención de requerimientos

Quiz

•

University

50 questions

Examen final hardware y software

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

database aws

Which type of database is Amazon DynamoDB?

How does Amazon DynamoDB achieve high availability and scalability across Regions?

Which statement describes the concept of partitioning in Amazon DynamoDB?

Which statement about Amazon DynamoDB partition keys is true?

How many ways can Amazon DynamoDB retrieve data from a DynamoDB table?

What is a database?

Which database attributes accurately represent elements of a relational database? (Select TWO.)

What are the primary features of a NoSQL database? (Select TWO.)

What is a data lake?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers