What is Analysis service repository?

Correct Answer: It is a way to convert the original text of the stored procedure into encrypted form The stored procedure gets obfuscated and the output of this is not visible to CREATE PROCEDURE Abc WITH ENCRYPTION AS << SELECT statement>> GO

Correct Answer: Only one column can exist per table that is attached with ROWGUIDCOL property One can then use $ROWGUID instead of column name in select list

Correct Answer: UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Correct Answer: It enables SQL server to address diverse data sources like OLE DB similarly It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions

Correct Answer: Amazon S3 provides uploading of large files and retrieve small offsets for end-to-end transfer data rates The large file gets stored into small files that are smaller in size Amazon S3 stores multiple of files together in a bundle or in a compressed form, For example in gzip or gz format and then convert them into Amazon S3 objects The files get uploaded on the Amazon server by the use of FTP or another protocol and then retrieved through the HTTP GET request The request includes the defined parameters like URL, offset (byte-range) and size (length)

Correct Answer: This command is used when a large processing of data has occurred If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account UPDATE_STATISTICS updates the indexes on these tables accordingly

Correct Answer: SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA) Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts

Correct Answer: SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition')

Correct Answer: - A clustered index is a special type of index that reorders the way records in the table are physically stored Therefore table can have only one clustered index - A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk The leaf node of a non clustered index does not consist of the data pages Instead, the leaf nodes contain index rows

Correct Answer: Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression) It might be also worth asking about performance as CTE is not always very fast