Answers:

Workspace $1205$ multi$-$dimensional SSIS PL$-$SQL $0$

$1433$ OLAP dcomcnfg RSCM T$-$SQL DTU

SSAS SPLIT partition function ReFS MaxDOP DDM

Query Store facts dimensions SSDT columnstore CEK

$1521$ OLTP partition scheme CHECKSUM $5022$ merge

snapshot DQS Resource Governor page Buffer Manager

$1.$ Port used by MSSQL for app access: $\_1433\_$

$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: $\_\_\_\_$