Question

1. Which of the following is a database client software?

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

2. Compared to Data Warehousing approach, the following are disadvantages 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

3. 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

4. In order to login to a non-local database server (i.e., use computer A to login to database hosted on computer B), what information is NOT required?

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

5. Which of the following is a WRONG statement?

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

6. Which of the following database roles has the highest privileges?

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

7. The attribute "Price" in the Sensor table is a/an _________ attribute.

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

Answer 1

1)

Ans)Option B is correct
Microsoft SQL Server Management Studio is a client database software

2)

Ans)Option C is correct
No storage wastes takes place in query driven data approch

3)

Ans)Option C is correct
OLAP stands for Online Analytical Processing

4)

Ans)Option D is correct option
Ip address, username and password are mandatory for remote connection and no of tables is not required

5)

Ans)Option D is correct option
Since SSH connection or any remote connection made to the EC2 instance is independent and won't affect any installation if connection is broken or closed

6)

Ans)Option D is correct option
A db_owner has privilege for almost all the configurations in the database.

7)

Ans)Option B is correct option
Since price is a decimal value so float is the appropriate choice and not integer or any other data type

NOTE:Please upvote if you liked my answer and comment if you need any modification or explanation.