MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.You need to enable the DNN application to connect to the report.What should you do? |
| A. | Modify the RSReportServer.config file. |
| B. | Deploy the report to the Report Server. |
| C. | Use the SSRS Web service. |
| D. | Modify the properties of ServerURL. |
| Answer» C. Use the SSRS Web service. | |
| 2. |
How much of earth surface is covered by the forests ? |
| A. | 40 percent |
| B. | 20 percent |
| C. | 25 percent |
| D. | 30 percent |
| Answer» E. | |
| 3. |
Coniferous forest regions are well developed in- |
| A. | Chernozem soils |
| B. | Laterite soils |
| C. | Podzol soils |
| D. | Red soils |
| Answer» D. Red soils | |
| 4. |
The vegetation which survives on aerial roots is- |
| A. | Mangrove |
| B. | selvas |
| C. | caatinga |
| D. | taiga |
| Answer» B. selvas | |
| 5. |
Bamboo and pine trees are generally found in which one of the following types of climates ? |
| A. | Taiga |
| B. | Tropical Monsoon |
| C. | Mediterranean |
| D. | Savanna |
| Answer» C. Mediterranean | |
| 6. |
Sarnath is in the state of- |
| A. | Kerala |
| B. | Maharashtra |
| C. | Gujrat |
| D. | Uttar Pradesh |
| Answer» E. | |
| 7. |
Thick stems and thorny wax coated leaves are commonly found in - |
| A. | River banks |
| B. | Deserts |
| C. | Deciduous forest |
| D. | flood plains |
| Answer» C. Deciduous forest | |
| 8. |
Sal and teak are commonly found in- |
| A. | Equatoria forest |
| B. | Mangrove forest |
| C. | Monsoon forest |
| D. | Savanna Forest |
| Answer» D. Savanna Forest | |
| 9. |
Plants which can tolerate considerable changes in moisture conditions are called- |
| A. | Xerophytes |
| B. | Mesophytes |
| C. | Tropophytes |
| D. | Hygrophytes |
| Answer» D. Hygrophytes | |
| 10. |
The minimum forest cover to maintain ecological balance is - |
| A. | 50% |
| B. | 40% |
| C. | 33% |
| D. | 25% |
| Answer» D. 25% | |
| 11. |
Plants of tropical and sub-tropical regions are called- |
| A. | Vegatherms |
| B. | Mesotherms |
| C. | Microtherms |
| D. | Hekhsotherms |
| Answer» B. Mesotherms | |
| 12. |
Which of the following countries in Africa has luxurious tropical rain forests- |
| A. | Ivory coast |
| B. | Kenya |
| C. | Zimbabwe |
| D. | Union of South Africa |
| Answer» B. Kenya | |
| 13. |
The greatest diversity of animal and species occurs in- |
| A. | Temperate deciduous forests |
| B. | Tropical moist forest |
| C. | Heavily polluted rivers |
| D. | Deserts and Savannas |
| Answer» C. Heavily polluted rivers | |
| 14. |
Which of the following is known for extensive tropical rain forest ? |
| A. | CongoBasin |
| B. | Ganga Basin |
| C. | Hwang Ho basin |
| D. | Murray Darling Basin |
| Answer» B. Ganga Basin | |
| 15. |
You work as a database administrator for ABC.com. The ABC.com network contains a database server named ABC-DB02 that is configured to host the SQL Server 2008 Analysis Services (SSAS) role. ABC-DB02 contains a single partition. You receive an instruction from the CIO to implement caching on the partition. Several times during the day the storage data is updated on ABC-DB02. You therefore need to configure the partition to ensure that the role is able to query the connected data whilst being updated. You then decide to make the necessary modifications to the ProcessingMode feature. What should your next step encompass? |
| A. | The partition should be modified to ProcessAdd |
| B. | The partition should be modified to Do Process. |
| C. | The partition should be modified to Immediate. |
| D. | The partition should be modified to Advanced. |
| Answer» D. The partition should be modified to Advanced. | |
| 16. |
You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05. You are in the process of deploying a SQL Server Analysis Services (SSAS) instance. The SSAS instance contains a dimension, named Exams, which has a property named Screen Shots. You are tasked with seeing that the aggregations and the Screen Shots property are not connected to each other. You decide to have the AttributeHierarchyEnabled feature configured to complete this task. Which of the following actions should you take? |
| A. | ABC-DB05 should be configured to True. |
| B. | The SSAS method should be configured to False. |
| C. | Exams should be configured to True. |
| D. | The Screen Shots feature should be configured to False. |
| Answer» E. | |
| 17. |
Most intensive farming is practiced in- |
| A. | China |
| B. | India |
| C. | Indonesia |
| D. | Japan |
| Answer» E. | |
| 18. |
You work as a database administrator for ABC.com. You are responsible for a SQL Server 2008 computer named ABC-DB01, which hosts a SQL Server 2008 Reporting Services (SSRS) sample. A new ABC.com policy permits users to move reports via e-mail. ABC-DB01 should therefore be configured for the delivery of e-mail. How can you configure ABC-DB01 to send or receive e-mail messages? |
| A. | The XML configuration file should be modified. |
| B. | The Report Server database should be modified. |
| C. | The RSReportServer.config file should be modified. |
| D. | The Web.config file should be disbaled. |
| Answer» D. The Web.config file should be disbaled. | |
| 19. |
You work as a database administrator for ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB01. ABC- DB01 is hosting the SQL Server Analysis Services (SSAS). ABC-DB01 hosts numerous measure groups including a group named ABCSales that makes more use of the refresh option that the other groups. You receive an instruction from the CIO to supervise ABCSales via ABC-DB01. You thus decide to monitor it in a table.How can you achieve this? |
| A. | The features of the AggregationFunction property should be modified. |
| B. | The features of the Caching property should be modified. |
| C. | The features of the ProactiveCaching property should be modified. |
| D. | The features of the TransactionOption property should be modified. |
| Answer» D. The features of the TransactionOption property should be modified. | |
| 20. |
The Lumbini was the birth place of Buddha is attested by an inscription of- |
| A. | Ashoka |
| B. | Pushyamitra Sung |
| C. | Kanishka |
| D. | Harsha |
| Answer» B. Pushyamitra Sung | |
| 21. |
You work as a database administrator for ABC.com. The ABC.com network has a SQL Server 2008 Analysis Services (SSAS) instance on a database server named ABC-DB05. ABC-DB05 contains a DataDir feature. You receive notification from management to change the feature to a folder named Features. It is imperative that Features is used in as little time as possible.How can you achieve this? |
| A. | By configuring the Analysis services. |
| B. | By using the SQL Server Destination. |
| C. | By running the database. |
| D. | By setting the query log using the Transaction Log Tool. |
| Answer» D. By setting the query log using the Transaction Log Tool. | |
| 22. |
You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 database server named ABC-DB01. You are in the process of creating a complex report on ABC-DB01 using SQL Server 2008 Reporting Services (SSRS). You receive an instruction to have the report cached for the first twenty minutes upon commencing the request. You then decide to configure ABC-DB01 to comply with the stipulation. Which of the following actions should you take? |
| A. | The Full cache option should be configured. |
| B. | You should configure the data source as a parameter from the data table. |
| C. | You should configure the Default cache option. |
| D. | Report execution caching should be configured. |
| Answer» E. | |
| 23. |
You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role. While querying ABC- DB05, you are presented with a Duplicate Key error. You receive an instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve this problem. Which of the following actions should you take? |
| A. | The store procedure should be modified. |
| B. | The Data Viewer object should be modified. |
| C. | The connection string should be modified. |
| D. | The dimension should be modified. |
| Answer» E. | |
| 24. |
You work as a database administrator at ABC.com. Your duties include administering a SQL Server 2008 Analysis Services (SSAS) sample named ABC-DB01. You receive an instruction from the CIO to log all queries. You then decide to make the necessary changes to the QueryLogconnection String feature. What should your next step be? |
| A. | You should modify the connection string to the default value. |
| B. | A valid connection string should be set on ABC-DB01. |
| C. | The source attribute should be set to 20. |
| D. | You should set the default value using Discover_Query. |
| Answer» C. The source attribute should be set to 20. | |
| 25. |
You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB03. You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for the ABC.com network. ABC.com has informed you that ABC- DB03 will be hosting the package. You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03 becomes inactive. How can this be achieved? |
| A. | The master database should be backed up. |
| B. | You should back up ABC-DB03. |
| C. | You should execute an incremental backup on a weekly basis. |
| D. | The SSIS package should be backed up. |
| Answer» B. You should back up ABC-DB03. | |
| 26. |
You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services (SSRS) instance. During routine monitoring, you discover that this instance does not render any extensions for Microsoft Office Word. How would you modify the instance to render these extensions? |
| A. | The Report Server database should be modified on ABC-DB01. |
| B. | The RSReportServer.config file should be modified on ABC-DB01. |
| C. | The XML configuration file should be modified onABC-DB01. |
| D. | The Web.config file should be modified on ABC-DB01. |
| Answer» C. The XML configuration file should be modified onABC-DB01. | |
| 27. |
The composition of the atmosphere: |
| A. | Varies from place to place |
| B. | Remains relatively constant in the lower layers |
| C. | varies with seasons |
| D. | varies with latitudes |
| Answer» C. varies with seasons | |
| 28. |
The lower layer of the atmosphere is known as: |
| A. | Mesosphere |
| B. | Stratosphere |
| C. | Ionosphere |
| D. | Troposphere |
| Answer» E. | |
| 29. |
Variations in duration of day and night are caused primarily because- |
| A. | The earth is spherical in shape |
| B. | The earth is revolving around the sun |
| C. | The earth is rotating at varying speed |
| D. | The axis of the earth is inclined |
| Answer» E. | |
| 30. |
The stratosphere is said to be ideal for flying jet aircraft. This is because- |
| A. | This layer is rich in ozone which reduces fuel consumption |
| B. | The temperature is constant and ideal for aircraft engine efficiency |
| C. | This layer is out of the firing range of antiaircraft guns |
| D. | Of the absence of the clouds and other weather phenomena |
| Answer» E. | |
| 31. |
The Vikramshila Mahavihara, a great centre of education was founded by- |
| A. | Baladitya |
| B. | Harsha |
| C. | Gopala |
| D. | Dharamapala |
| Answer» E. | |
| 32. |
Nights are cooler in the deserts than in the plains because: |
| A. | sand radiates more quickly than the earth |
| B. | the sky remains clear most of the time |
| C. | sand absorbs heat more quickly than the earth |
| D. | none of these |
| Answer» B. the sky remains clear most of the time | |
| 33. |
The ozone layer in the upper part of the atmosphere protects us from: |
| A. | Cosmic rays |
| B. | Ultrasonic waves |
| C. | Infra-red rays |
| D. | Ultraviolet rays |
| Answer» E. | |
| 34. |
Most of the phenomena related to weather take place in - |
| A. | stratosphere |
| B. | ionosphere |
| C. | mesosphere |
| D. | troposphere |
| Answer» E. | |
| 35. |
Television signal cannot be received generally beyond a particular distance due to- |
| A. | Curvature of the earth |
| B. | Weakness of antenna |
| C. | weakness of signal |
| D. | absorption of signal in air |
| Answer» B. Weakness of antenna | |
| 36. |
Which one of the following zones of the atmosphere is rich in ozone gas? |
| A. | Mesosphere |
| B. | Troposphere |
| C. | Stratosphere |
| D. | Lonosphere |
| Answer» D. Lonosphere | |
| 37. |
The ocean of Storms is the name given to- |
| A. | Atlantic ocean |
| B. | Pacific Ocean |
| C. | A waterless area on moon surface |
| D. | None of these |
| Answer» D. None of these | |
| 38. |
The doctrine of three jewels-Right belief, Right Conduct and Right knowledge is the crownings glory of- |
| A. | Buddhism |
| B. | Christianity |
| C. | Jainism |
| D. | None of these |
| Answer» D. None of these | |
| 39. |
Which of the following is a measure of solar radiation energy received on a given surface area in a given time- |
| A. | Radiation |
| B. | Reflection |
| C. | Insolation |
| D. | Refraction |
| Answer» D. Refraction | |
| 40. |
The layer of the Earth s atmosphere that is directly above the stratosphere and directly below the thermosphere is called - |
| A. | Mesopause |
| B. | Stratopause |
| C. | Isothermal layer |
| D. | Mesosphere |
| Answer» E. | |
| 41. |
Which of the following is quantified as the proportion, or percentage of solar radiation of all wavelengths reflected by a body or surface to the amount incident upon it. |
| A. | Radiation |
| B. | Reflection |
| C. | Insolation |
| D. | Albedo |
| Answer» E. | |
| 42. |
The last atmospheric layer has an altitude greater than 80 kilometers and is called- |
| A. | Mesopause |
| B. | Stratoopause |
| C. | Isotheramal Layer |
| D. | Thermosphere |
| Answer» E. | |
| 43. |
Which of the following layer of the atmosphere has electricity conducting layers which make short wave radio transmission possible long distances ? |
| A. | Mesopause |
| B. | Stratopause |
| C. | Isothermal Layer |
| D. | Lonosphere |
| Answer» E. | |
| 44. |
At the top of the mesosphere is another transition zone known as - |
| A. | Mesopause |
| B. | Stratopause |
| C. | Isothermal layer |
| D. | None of these |
| Answer» B. Stratopause | |
| 45. |
Abc.com has hired you as a database administrator for their network. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) database named CKProducts for Abc.com. CKProducts contains a number of measure groups. A measure group named Product Data permits the refresh option more frequently than the other measure groups. You need to ensure that Product Data functions on a schedule managed through SSAS. What should you do? |
| A. | You should consider changing the features of the ProactiveCaching property. |
| B. | You should consider changing the features of the DataAggregation property. |
| C. | You should consider changing the features of the Caching property. |
| D. | You should consider changing the features of the ProcessingPriority property. |
| Answer» B. You should consider changing the features of the DataAggregation property. | |
| 46. |
You work as a database administrator at Abc.com. Your duties include managing a SQL Server Analysis Services (SSAS) database named ABC- DB01. ABC-DB01 is configured to use security roles and is managed through a Microsoft ASP.NET application that is not located on ABC-DB01. You need to use Windows Authentication for the application. You need to ensure that the application users are able to access the SSAS database normally. You should also ensure that the security restrictions role is permitted. What should you do? |
| A. | You should consider setting Kerberos as the authentication method. |
| B. | You should consider setting HTTP configurations for authentication purposes. |
| C. | You should consider configuring Web Services for HTTP authentication purposes. |
| D. | You should consider setting the SecurityAuthentication feature to false to disable it. |
| Answer» B. You should consider setting HTTP configurations for authentication purposes. | |
| 47. |
You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database for Abc.com. The SSAS database contains a dimension named CKOrders. You are in the process of updating a role named Analyze. You decide to set the security for the Managers role at a later stage. You need to ensure that member of the Managers role are able to run data based on two or less customers. What should you do? |
| A. | You should consider removing the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role. |
| B. | You should consider adding the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role. |
| C. | You should consider inserting the expression: [CKOrders].CurrentMember,,LEAVES).Count u003c= 2 |
| D. | You should consider inserting the expression |
| Answer» D. You should consider inserting the expression | |
| 48. |
You work as a database developer at Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. You enable caching for a partition. You want to make sure that the SSAS method can query connected data when you update storage aspects. What should you do? |
| A. | You should set the ProcessingMode property of the partition to Immediate. |
| B. | You should set the ProcessingMode property of the partition to LazyAggregations. |
| C. | You should set the ProcessingMode property of the partition to OnCacheComplete. |
| D. | You should set the ProcessingMode property of the partition to True. |
| Answer» B. You should set the ProcessingMode property of the partition to LazyAggregations. | |
| 49. |
Buddha was born at - |
| A. | Vaishali |
| B. | Lumbini |
| C. | Kapilvastu |
| D. | Pataliputra |
| Answer» C. Kapilvastu | |
| 50. |
You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The SSAS method contains a dimension and a measure group. The dimension is named CKTime and the measure group is named CKProducts. CKTime includes a property named _Month. CKProducts connects with the CKTime dimension. You need to ensure that the design on CKProduct contain the _Month property. What should you do? |
| A. | You should configure the AttributeHierarchyEnabled feature. |
| B. | You should configure the AttributeHierarchyDisabled feature. |
| C. | You should configure the AggregationUsage feature. |
| D. | You should configure the Usage feature. |
| Answer» D. You should configure the Usage feature. | |