Tag: databases

Questions Related to databases

What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) >5
technology databases

  1. Selects the total number of orders from the Sales table, if this number is greater than 5

  2. Selects all Customers from the Sales table

  3. Both of them above

  4. Selects all customers from table Sales that have made more than 5 orders

Show answer
Correct Option: D

What does the SQL FROM clause do?
technology databases

  1. Specifies data retrieved

  2. Specifies the tables to retrieve rows from.

  3. Specifies the columns we are retrieving.

  4. Specifies a search condition.

Show answer
Correct Option: B

Which Service / Server would be used to host the OLTP data?
technology databases

  1. SSAS

  2. SSIS

  3. SQL RDBMS

  4. SSRS

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to have an understanding of the different services/servers in Microsoft SQL Server and their purposes.

SSAS (SQL Server Analysis Services) is used for creating and managing OLAP (Online Analytical Processing) databases, which are used for data analysis and business intelligence.

SSIS (SQL Server Integration Services) is used for data integration and migration, including ETL (Extract, Transform, Load) processes.

SSRS (SQL Server Reporting Services) is used for creating and managing reports based on data stored in a SQL Server database.

C. SQL RDBMS (Relational Database Management System) is the correct option for hosting OLTP (Online Transaction Processing) data. OLTP databases are optimized for the rapid processing of transactions, such as inserting, updating, and deleting data. SQL RDBMS is designed to manage relational databases, which are commonly used for OLTP applications.

Therefore, the correct answer is:

The Answer is: C

Which Service / Server would be used to host the Staging data
technology databases

  1. SSAS

  2. SSIS

  3. SQL RDBMS

  4. SSRS

Show answer
Correct Option: C

What are the reasons for switching to a solution using Business Intelligence? Select all the options that are applicable.
technology databases

  1. Slow queries

  2. Disparate Data sources

  3. Invalid / Inconsistent report data

  4. Availability of data to all users

Show answer
Correct Option: A

You are in the process of deploying Analysis Services Database in the production environment. You are using the Analysis Services Deployment Wizard to perform this deployment. The project will be named Deploy_Prod1.During the deployment process, you want to retain the existing roles and role members on the destination server.Which input file should you modify to accomplish the objective?
technology databases

  1. .asdatabase

  2. .deploymenttargets

  3. .configsettings

  4. .deploymentoptions

Show answer
Correct Option: D

Limiting the rows in a select statement for a specific condition is done by the clause
technology databases

  1. Distinct

  2. Projection

  3. Where

  4. All of the above

Show answer
Correct Option: C

SYSDATE is a date function that returns the current database server date and time.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The value returned by the subquery is used by the main query.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Character values are case insensitive
technology databases

  1. True

  2. False

Show answer
Correct Option: B