ITF+ Programming & Database

What is another term used to refer to a field?

• Column
  

• Row

• Collection

• Foreign key
  

Your database has grown over time, and you need to improve query performance. What should you do? (Choose two.)

• Perform a database dump

  
  

• Remove infrequently accessed data

  
  

• Create an index for queried data

  
  

• Create a foreign key

  
  

You have increased the amount of RAM available for your cloud-based database instance. Which term describes this action?

• Scaling in

  
  

• Scaling down

  
  

• Scaling out

  
  

• Scaling up
  

You have increased the number of compute nodes for your cloud-based database instance. Which term describes this action?

• Scaling in

  
  

• Scaling down

  
  

• Scaling out

  
  

• Scaling up
  

You have configured a database in the headquarters office located in Houston, Texas. Your company has office in major cities across Canada and the United States. Users in Eastern Canada complain about slow query access to the database, while Texas users enjoy fast performance. What should you do?

• Place a read replica in Eastern Canada

  
  

• Create an index

  
  

• Place a writeable replica in Eastern Canada

  
  

• Create a foreign key
  

Which unit of measurement relates to disk throughput?

• MHz

• GHz

• IOPS (Input and Output Operations Per Second)

  
  

• Uptime

Which type of database does not use a rigid schema?

• Relational

• On-premises

  
  

• Cloud

• NoSQL

Which type of database uses a rigid schema?

• Relational

• On-premises

  
  

• Cloud

• NoSQL

What statement regarding NoSQL databases is correct? (Choose two.)

• Each row must store the same type of data.

  
  

• They are less scalable than relational databases.

  
  

• Each row can store different types of data.

  
  

• They are more scalable than relational databases.

  
  

Which of the following is a NoSQL database? (pick the odd one)

• Microsoft SQL Server

  
  

• MongoDB

• Oracle Database

  
  

• MySQL