Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . Port used by MSSQL for app access: _ _ _ _ 2 . Index used on a data warehouse to speed data mining

1. Port used by MSSQL for app access: ____
2. Index used on a data warehouse to speed data mining operations: ____
3. Port used by OracleDB for app access: ____
4. Used to encrypt columns for AlwaysEncrypted: ____
5. Another term for a production database: ____
6. Produces detailed query statistics for a particular database: ____
7. Default port used by database mirroring: ____
8. The unit of charge ($) when hosting a SQL database within Azure: ____
9. A read-only publication: ____
10. Tool used to configure SQL Server Reporting Services: ____
11. Program used to perform data mining: ____
12. Defines boundaries in a database partitioning configuration: _____
13. The portion of an OracleDB that apps connect to:____
14. Default value for the Page Verify database option: ____
15. The SQL dialect used by OracleDB: _____
16. Another term for a data warehouse: _____
17. A read-write publication: ____
18. Determines which filegroups data is stored in within a database partitioning configuration: ______
19. The data within a data warehouse that categorizes measureable values (e.g. by country, customer, date, etc.): ____
20. Service used to perform data mining: ____
21. A data mining mode that visualizes data as a cube: _____
22. A feature used to hide sensitive data from view by users: ____
23. Tool used to delegate permissions to the SSIS service: ____
24. The SQL dialect used by Microsoft SQL Server: ____
25. A setting that allows queries to perform faster on multi-core/CPU systems: ____
26. The SQL Server performance object that measures SQL RAM usage: ____
27. A service used to ensure the correctness of user-entered data: _____
28. Preferred filesystem for use with Storage Spaces: ____
29. The licensing cost of the Ubuntu Linux operating system: ____
30. Error number for deadlocks: ____
31. Service used to copy data from a production database to a data warehouse: _____
32. SQL statement used to subdivide database partitions: _____
33. The data within a data warehouse that stores measureable values: _____
34. Type of compression that eliminates duplicate values: ____
35. Feature used to throttle (or guarantee) resources to SQL instances and queries: ____

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning PostgreSQL On The Cloud Simplifying Database As A Service On Cloud Platforms

Authors: Baji Shaik ,Avinash Vallarapu

1st Edition

1484234464, 978-1484234464

More Books

Students also viewed these Databases questions