MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 33 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Valid syntax for REFRESH CUBE statement is ____________ |
| A. | REFRESH CUBECube_Name |
| B. | REFRESH CUBE Cube_Name |
| C. | REFRESH CUBE “Cube_Name” |
| D. | REFRESH CUBE \Cube_Name\ |
| Answer» B. REFRESH CUBE Cube_Name | |
| 2. |
Which of the following statement is used to retrieve rows from the view ExecutionLog3? |
| A. | select * from ExecutionLog3 order by TimeStart DESC |
| B. | select * from ExecLog3 order by TimeStart DESC |
| C. | select * from ExecutionLog4 order by TimeStart DESC |
| D. | none of the mentioned |
| Answer» B. select * from ExecLog3 order by TimeStart DESC | |
| 3. |
Fill From Example tool also produces a patterns report similar to ___________ |
| A. | Analyze Key Influencers |
| B. | Detect Categories |
| C. | Fill From Example |
| D. | None of the mentioned |
| Answer» B. Detect Categories | |
| 4. |
Which of the following keyword forces a specified set to be evaluated within the current context? |
| A. | SCOPE |
| B. | CASE |
| C. | EXISTING |
| D. | FREEZE |
| Answer» D. FREEZE | |
| 5. |
Which of the following is valid syntax for DRILLTHROUGH statement? |
| A. | DRILLTHROUGH[MAXROWSUnsigned_Integer] |
| B. | DRILL[MAXROWSUnsigned_Integer] |
| C. | DRILLTHROUGH[MAXROWSUnsigned_Integer] |
| D. | None of the mentioned |
| Answer» B. DRILL[MAXROWSUnsigned_Integer] | |
| 6. |
If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression? |
| A. | Weight_Expression = <leaf cell value> * <existing value> |
| B. | Weight_Expression = <leaf cell value> / <existing value> |
| C. | Weight_Expression = <leaf cell value> – <existing value> |
| D. | Weight_Expression = <leaf cell value> + <existing value> |
| Answer» C. Weight_Expression = <leaf cell value> – <existing value> | |
| 7. |
Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method? |
| A. | <leaf cell value> = |
| B. | <leaf cell value> = < NEW Value> * Weight_Expression |
| C. | <leaf cell value> = <leaf cell value> + |
| D. | <leaf cell value> = <leaf cell value> + |
| Answer» D. <leaf cell value> = <leaf cell value> + | |
| 8. |
When you include a many-to-many dimension, which of the following rules apply? |
| A. | You must add the intermediary measure group |
| B. | You must add the entire many-to-many dimension |
| C. | You must add the entirety of all dimensions common to the two measure groups involved in the many-to-may relationship |
| D. | All of the mentioned |
| Answer» E. | |
| 9. |
Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison? |
| A. | EnableFast1033Local |
| B. | EnableFast1036Locale |
| C. | EnableFast1033Locale |
| D. | EnableQuick1033Locale |
| Answer» D. EnableQuick1033Locale | |
| 10. |
Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character? |
| A. | BIN2 (_BIN2)1 |
| B. | Binary (_BIN)1 |
| C. | Case-sensitive (_CS) |
| D. | Case-insensitive |
| Answer» C. Case-sensitive (_CS) | |
| 11. |
____________ distinguishes between a single-byte character and the same character when represented as a double-byte character. |
| A. | Accent-insensitive (_AI) |
| B. | Kana-sensitive (_KS) |
| C. | Accent-sensitive (_AS) |
| D. | Width-sensitive (_WS) |
| Answer» E. | |
| 12. |
You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values. |
| A. | BI |
| B. | ETL |
| C. | MIS |
| D. | OBIEE |
| Answer» B. ETL | |
| 13. |
Which of the following is valid syntax for CREATE GLOBAL CUBE? |
| A. | CREATE GLOBAL CUBE [LocalReseller] |
| B. | CREATE GLOBAL CUBE [LocalReseller] |
| C. | CREATE GLOBAL CUBE [LocalReseller] |
| D. | All of the mentioned |
| Answer» B. CREATE GLOBAL CUBE [LocalReseller] | |
| 14. |
Which of the following is the MDX Data Definition Statement? |
| A. | CREATE ACTION |
| B. | DROP CUBE |
| C. | CREATE CUBE |
| D. | None of the mentioned |
| Answer» B. DROP CUBE | |
| 15. |
The following code is a syntax of which statement? |
| A. | CREATE SESSION |
| B. | CREATE CUBE |
| C. | CREATE MEMBER |
| D. | CREATE MDX |
| Answer» D. CREATE MDX | |
| 16. |
Which of the following property is set to zero so that all levels are not created? |
| A. | Aggregatable |
| B. | IsAggregatable |
| C. | IsAggregate |
| D. | All of the mentioned |
| Answer» C. IsAggregate | |
| 17. |
Which of the following is not supported by linked dimensions? |
| A. | readback |
| B. | writeback |
| C. | readwrite |
| D. | all of the mentioned |
| Answer» C. readwrite | |
| 18. |
Which of the following is a list type in RDL with base 64 encoded value? |
| A. | Boolean |
| B. | Binary |
| C. | Enum |
| D. | Name |
| Answer» C. Enum | |
| 19. |
Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created? |
| A. | Database |
| B. | Membership |
| C. | Client |
| D. | Server |
| Answer» B. Membership | |
| 20. |
If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server. |
| A. | ImpersonateAnon |
| B. | Anonymous |
| C. | ImpersonateAnonymous |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 21. |
Which of the following namespace discover set of assemblies? |
| A. | System.Reflection |
| B. | System.Refraction |
| C. | Sys.Reflection |
| D. | All of the mentioned |
| Answer» B. System.Refraction | |
| 22. |
Which of the following permission setting provides internal computation permission? |
| A. | Unsafe |
| B. | ExternalAccess |
| C. | Safe |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 23. |
_________ let you create external, user-defined functions using any common language runtime (CLR) language. |
| A. | Aggregate |
| B. | Assemblies |
| C. | Synonym |
| D. | All of the mentioned |
| Answer» C. Synonym | |
| 24. |
If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________ |
| A. | client |
| B. | server |
| C. | table |
| D. | none of the mentioned |
| Answer» C. table | |
| 25. |
Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table? |
| A. | Exceptions |
| B. | Highlight |
| C. | Scenario Analysis |
| D. | Highlight Exceptions |
| Answer» E. | |
| 26. |
___________ analyzes the patterns in data that have the strongest influence on a certain outcome. |
| A. | Analyze Key Influencers |
| B. | Detect Categories |
| C. | Fill From Example |
| D. | None of the mentioned |
| Answer» B. Detect Categories | |
| 27. |
_________ is a category of applications and technologies for presenting and analyzing corporate and external data. |
| A. | Data warehouse |
| B. | MIS |
| C. | EIS |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 28. |
Which of the following is the process of basing an organization’s actions and decisions on actual measured results of performance? |
| A. | Institutional performance management |
| B. | Gap analysis |
| C. | Slice and Dice |
| D. | None of the mentioned |
| Answer» B. Gap analysis | |
| 29. |
Which of the following does not form part of BI Stack in SQL Server? |
| A. | SSRS |
| B. | SSIS |
| C. | SSAS |
| D. | OBIEE |
| Answer» E. | |
| 30. |
Business intelligence (BI) is a broad category of application programs which includes _____________ |
| A. | Decision support |
| B. | Data mining |
| C. | OLAP |
| D. | All of the mentioned |
| Answer» E. | |
| 31. |
BI can catalyze a business’s success in terms of _____________ |
| A. | Distinguish the products and services that drive revenues |
| B. | Rank customers and locations based on profitability |
| C. | Ranks customers and locations based on probability |
| D. | All of the mentioned |
| Answer» E. | |
| 32. |
Which of the following areas are affected by BI? |
| A. | Revenue |
| B. | CRM |
| C. | Sales |
| D. | All of the mentioned |
| Answer» C. Sales | |
| 33. |
________ is a performance management tool that recapitulates an organization’s performance from several standpoints on a single page. |
| A. | Balanced Scorecard |
| B. | Data Cube |
| C. | Dashboard |
| D. | All of the mentioned |
| Answer» B. Data Cube | |