80.2K

Verified Solution

Link Copied!

1. Which of the following is a database clientsoftware?

1. Microsoft SQL Server 2017 Developer
2. Microsoft SQL Server Management Studio
3. Microsoft SQL Server Configuration Manager
4. SQL Server Analysis Service

1. Compared to Data Warehousing approach, the following aredisadvantages of query-driven data integration approach, EXCEPT:__________.

1. competition with local processing at source
2. delay in query processing
3. waste of storage space
4. inefficient and potentially expensive for frequent queries

1. What does OLAP stand for?

1. Olympic Linear Algebra Problem
2. On-Line Amazon Platform
3. On-Line Analytical Processing
4. One Lazy Associate Professor

1. In order to login to a non-local database server (i.e., usecomputer A to login to database hosted on computer B), whatinformation is NOT required?

1. username
2. password
3. IP address of the database server
4. Number of tables in the database

1. Which of the following is a WRONG statement?

1. If you stop your t3-medium EC2 instance whenever you don’t useit, you can save money.
2. If you terminate your EC 2 instance, everything inside yourinstance is also deleted.
3. If you stop your EC2 instance during installation of somesoftware, the installation will fail.
4. If you close your remote desktop connection (or SSH) to EC2instance, any ongoing process (e.g., installing software, runningSQL queries) inside EC2 is interrupted.

1. Which of the following database roles has the highestprivileges?

1. db_datareader
2. db_datawriter
3. db_securityadmin
4. db_owner

1. The attribute \"Price\" in the Sensor table isa/an _________ attribute.

1. int
2. float
3. varchar
4. datetime