MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 424 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue. |
| A. | FireEvent |
| B. | FireEventdata |
| C. | Eventdata |
| D. | None of the mentioned |
| Answer» B. FireEventdata | |
| 52. |
The Schedule and Delivery Processing feature must be enabled through the ____________ property. |
| A. | ScheduleEventsDeliveryEnabled |
| B. | ScheduleEventsAndReportDeliveryEnabled |
| C. | ScheduleEventsAndReportDelivery |
| D. | All of the mentioned |
| Answer» C. ScheduleEventsAndReportDelivery | |
| 53. |
__________ are portable, multipurpose items that contain ready-to-use schedule information. |
| A. | Report-specific schedule |
| B. | Shared schedules |
| C. | File schedules |
| D. | None of the mentioned |
| Answer» C. File schedules | |
| 54. |
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 | |
| 55. |
An ___________ report is a fully paged report saved in a specific file format. |
| A. | exported |
| B. | fully processed |
| C. | Compiled |
| D. | All of the mentioned |
| Answer» B. fully processed | |
| 56. |
You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode. |
| A. | Native, Sharepoint |
| B. | Sharepoint, Native |
| C. | Native, Native |
| D. | Sharepoint, Sharepoint |
| Answer» B. Sharepoint, Native | |
| 57. |
A _________ is an item stored internally in an alerting database. |
| A. | Connection string |
| B. | Data alert |
| C. | Shared data source |
| D. | None of the mentioned |
| Answer» C. Shared data source | |
| 58. |
A __________ is a report server item that contains a pointer to the report definition. |
| A. | Drilldown report |
| B. | Linked report |
| C. | Subreport |
| D. | Drillthrough report |
| Answer» C. Subreport | |
| 59. |
A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information. |
| A. | Main |
| B. | Detail |
| C. | Drillthrough |
| D. | All of the mentioned |
| Answer» E. | |
| 60. |
Reports use __________ to retrieve data for a report when a query runs or when the report is processed. |
| A. | Data connections |
| B. | Data source definition |
| C. | Connection string |
| D. | All of the mentioned |
| Answer» B. Data source definition | |
| 61. |
_______ is a tool to configure and manage a report server connection to the report server database. |
| A. | Rskeymgmt Utility |
| B. | Windows Management Instrumentation (WMI) Classes |
| C. | Rsconfig Utility |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 62. |
____________ does not help you manage report server content, enable additional features, or grant access to the server. |
| A. | Reporting Services Configuration Manager |
| B. | SSMS |
| C. | SQL Server Configuration Manager |
| D. | None of the mentioned |
| Answer» E. | |
| 63. |
When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes. |
| A. | USE_EQUAL_ALLOCATION |
| B. | USE_WEIGHTED_ALLOCATION |
| C. | USE_WEIGHTED_INCREMENT |
| D. | All of the mentioned |
| Answer» C. USE_WEIGHTED_INCREMENT | |
| 64. |
Which of the following keyword forces a specified set to be evaluated within the current context ? |
| A. | SCOPE |
| B. | CASE |
| C. | EXISTING |
| D. | EXISTING |
| Answer» D. EXISTING | |
| 65. |
If a weight expression is not specified, the UPDATE CUBE statement implicitly uses the following expression: |
| A. | Weight_Expression = * |
| B. | Weight_Expression = / |
| C. | Weight_Expression = – |
| D. | Weight_Expression = + |
| Answer» C. Weight_Expression = – | |
| 66. |
_______ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation. |
| A. | UPDATE CUBE |
| B. | DELETE CUBE |
| C. | ALTER CUBE |
| D. | None of the mentioned |
| Answer» B. DELETE CUBE | |
| 67. |
When you include a many-to-many dimension, 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. | |
| 68. |
________ is the set of hierarchies from which data is retrieved for a single member. |
| A. | Slicer axis |
| B. | Query axes |
| C. | Dice axis |
| D. | All of the mentioned |
| Answer» B. Query axes | |
| 69. |
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 | |
| 70. |
Which of the following is MDX Data Definition Statement ? |
| A. | CREATE ACTION |
| B. | DROP CUBE |
| C. | CREATE CUBE |
| D. | None of the mentioned |
| Answer» B. DROP CUBE | |
| 71. |
_______ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube. |
| A. | CREATE CELL CALCULATION |
| B. | CREATE CELL CALC |
| C. | CREATE MEMBER CALCULATION |
| D. | None of the mentioned |
| Answer» B. CREATE CELL CALC | |
| 72. |
The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility. |
| A. | {\} |
| B. | {*} |
| C. | {+} |
| D. | {-} |
| Answer» C. {+} | |
| 73. |
_____ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script. |
| A. | Ignore |
| B. | IgnoreNone |
| C. | IgnoreAll |
| D. | All of the mentioned |
| Answer» C. IgnoreAll | |
| 74. |
______ lets you manage cube context from within an MDX script. |
| A. | CALCULATE |
| B. | CALCULATE |
| C. | CALCULATE |
| D. | None of the mentioned |
| Answer» B. CALCULATE | |
| 75. |
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 | |
| 76. |
__________ 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. | |
| 77. |
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) | |
| 78. |
If you select the __________ conversion type, a reporting currency dimension is also created. |
| A. | one-to-one |
| B. | many-to-one |
| C. | many-many |
| D. | All of the mentioned |
| Answer» C. many-many | |
| 79. |
The Business Intelligence Wizard supports ______ different types of currency conversion. |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» B. 4 | |
| 80. |
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 | |
| 81. |
For _________ currency conversions, the pivot currency and reporting currency are the same. |
| A. | one-to-one |
| B. | many-to-one |
| C. | many-many |
| D. | All of the mentioned |
| Answer» C. many-many | |
| 82. |
____ is currency used to store transactions on which measures to be converted are based in SSAS. |
| A. | Local currency |
| B. | Pivot currency |
| C. | Global currency |
| D. | None of the mentioned |
| Answer» B. Pivot currency | |
| 83. |
Parent-child hierarchies are automatically detected by the _________ Wizard. |
| A. | Dimension |
| B. | Cube |
| C. | Dimension and Cube |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 84. |
By default, in a ________ schema, all attributes are directly related to the key attributes. |
| A. | Relational |
| B. | Snowflake |
| C. | Star |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 85. |
The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact tab |
| A. | Dim |
| B. | KEY |
| C. | PK |
| D. | None of the mentioned |
| Answer» C. PK | |
| 86. |
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 | |
| 87. |
Security for stored procedures is set with the _________ property on a stored procedure. |
| A. | PermissionSet |
| B. | SetPermissionSet |
| C. | Permission |
| D. | None of the mentioned |
| Answer» B. SetPermissionSet | |
| 88. |
In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension. |
| A. | Translation |
| B. | Dimension translation |
| C. | Dim translation |
| D. | None of the mentioned |
| Answer» C. Dim translation | |
| 89. |
________ 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 | |
| 90. |
Which of the following does not form part of BI Stack in SQL Server ? |
| A. | SSRS |
| B. | SSIS |
| C. | SSAS |
| D. | OBIEE |
| Answer» E. | |
| 91. |
Which of the following is 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 | |
| 92. |
________ 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 | |
| 93. |
______ is a system where operations like data extraction, transformation and loading operations are executed. |
| A. | Data staging |
| B. | Data integration |
| C. | ETL |
| D. | None of the mentioned |
| Answer» B. Data integration | |
| 94. |
_______ 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 | |
| 95. |
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. | |
| 96. |
_________ lets you affinitize a resource pool to one or more schedulers or NUMA nodes for greater isolation of CPU resources. |
| A. | MAX_IOPS_PER_VOLUME |
| B. | AFFINITY |
| C. | MAX_CPU_PERCENT |
| D. | MAX_MEMORY_PERCENT |
| Answer» C. MAX_CPU_PERCENT | |
| 97. |
Which of the following formula is used for calculating the effective MAX% ? |
| A. | 100 – sum(MIN %) |
| B. | min(X,Y) |
| C. | max(X,Y) |
| D. | Effective MAX % – MIN % |
| Answer» C. max(X,Y) | |
| 98. |
___________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool. |
| A. | MIN_CPU_PERCENT |
| B. | CAP_CPU_PERCENT |
| C. | MAX_CPU_PERCENT |
| D. | MAX_MEMORY_PERCENT |
| Answer» C. MAX_CPU_PERCENT | |
| 99. |
The query processor uses a __________ execution strategy for queries that select from partitioned objects. |
| A. | distributed |
| B. | parallel |
| C. | lock |
| D. | none of the mentioned |
| Answer» C. lock | |
| 100. |
Which of the following partitioned attribute can appear in the following physical and logical operators ? |
| A. | Index Seek |
| B. | Drop |
| C. | Alter |
| D. | None of the mentioned |
| Answer» B. Drop | |