InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Backing up your SQL Server database is essential for _______ your data.(a) protecting(b) preventing(c) replication(d) none of the mentionedI got this question during an interview for a job.I'm obligated to ask this question of Backup topic in portion Enterprise Data Management of SQL Server |
|
Answer» The correct answer is (a) protecting |
|
| 52. |
Which of the following statement is used for changing Recovery Model with T-SQL?(a) ALTER DATABASE(b) ALTER TABLE(c) ALTER COLUMN(d) None of the mentionedThis question was addressed to me in an interview for job.This intriguing question originated from Recovery in chapter Enterprise Data Management of SQL Server |
|
Answer» Correct answer is (a) ALTER DATABASE |
|
| 53. |
How many types of backups you can run when the data is in the “Full” recovery model?(a) 5(b) 6(c) 7(d) All of the mentionedI had been asked this question in a job interview.The doubt is from Recovery topic in portion Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (B) 6 |
|
| 54. |
The _______ recovery model is a special-purpose model that works in a similar manner to the full recovery model.(a) Simple(b) Full(c) bulk-logged(d) None of the mentionedThis question was addressed to me during an internship interview.My question is from Recovery topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct CHOICE is (C) bulk-logged |
|
| 55. |
Which of the following recovery models requires log backups?(a) Simple(b) Full(c) Bulk(d) All of the mentionedThis question was posed to me in examination.The doubt is from Recovery in division Enterprise Data Management of SQL Server |
|
Answer» The correct answer is (b) FULL |
|
| 56. |
Which of the following feature cannot be used in simple recovery mode?(a) Media recovery without data loss(b) Log shipping(c) Database mirroring(d) All of the mentionedThis question was posed to me during an online exam.Query is from Recovery topic in portion Enterprise Data Management of SQL Server |
|
Answer» Right option is (d) All of the mentioned |
|
| 57. |
No log backups is a feature of __________ recovery model.(a) Simple(b) Full(c) Bulk-logged(d) All of the mentionedI got this question during an interview.Asked question is from Recovery topic in division Enterprise Data Management of SQL Server |
|
Answer» The correct option is (a) SIMPLE |
|
| 58. |
Point out the wrong statement.(a) Managing databases with simple recovery model is much easier(b) Managing databases with full recovery model is much easier(c) Managing databases with bulk-logged recovery model is much easier(d) All of the mentionedThis question was addressed to me in an online quiz.Asked question is from Recovery topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The correct CHOICE is (a) Managing databases with simple recovery model is MUCH easier |
|
| 59. |
How many types of recovery model is provided by SQL Server?(a) 2(b) 3(c) 4(d) 5I got this question in an interview for job.The above asked question is from Recovery in section Enterprise Data Management of SQL Server |
|
Answer» Correct CHOICE is (b) 3 |
|
| 60. |
Point out the correct statement.(a) Backup models are designed to control transaction log maintenance(b) Restore models are designed to control transaction log maintenance(c) Recovery models are designed to control transaction log maintenance(d) None of the mentionedI had been asked this question in unit test.I would like to ask this question from Recovery topic in portion Enterprise Data Management of SQL Server |
|
Answer» Right answer is (c) Recovery MODELS are designed to control transaction log maintenance |
|
| 61. |
Purpose of syspolicy_system_health_state in policy based management is ______________(a) Displays one row for each Policy-Based Management policy(b) Organize policies when you have many policies(c) Displays the time when policies were executed, the result of each execution, and details about errors if any occurred(d) None of the mentionedThis question was addressed to me in an international level competition.Origin of the question is Policy Based Management topic in portion Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (a) Displays one row for each Policy-Based Management policy |
|
| 62. |
SQL Server backup and restore operations occur within the context of the _______ model of the database.(a) backup(b) recovery(c) restore(d) none of the mentionedI had been asked this question during an online exam.I'd like to ask this question from Recovery in division Enterprise Data Management of SQL Server |
|
Answer» Right ANSWER is (b) RECOVERY |
|
| 63. |
____________ displays the condition expressions that were executed.(a) syspolicy_policy_execution(b) syspolicy_policy_execution_history_details(c) syspolicy_policy_execution_history(d) syspolicy_policy_group_subscriptionsI got this question in a job interview.I want to ask this question from Policy Based Management topic in chapter Enterprise Data Management of SQL Server |
|
Answer» The CORRECT answer is (B) syspolicy_policy_execution_history_details |
|
| 64. |
How many types of execution mode are present in syspolicy_policies?(a) 2(b) 3(c) 4(d) 5The question was posed to me in class test.Question is from Policy Based Management in division Enterprise Data Management of SQL Server |
|
Answer» The correct CHOICE is (c) 4 |
|
| 65. |
Which of the following column is a part of syspolicy_policies result?(a) name(b) root_condition_id(c) date_created(d) all of the mentionedThe question was posed to me in an internship interview.This question is from Policy Based Management topic in chapter Enterprise Data Management of SQL Server |
|
Answer» Correct OPTION is (d) all of the mentioned |
|
| 66. |
Policy based management view is owned by _______ schema.(a) dbo(b) db(c) dbos(d) all of the mentionedI had been asked this question in final exam.The query is from Policy Based Management in division Enterprise Data Management of SQL Server |
|
Answer» RIGHT CHOICE is (a) dbo The best explanation: All POLICY based views are OWNED by default. |
|
| 67. |
Point out the wrong statement.(a) When SQL Server policy administrators use Policy-Based Management, they use SQL Server Management Studio(b) SQL server has introduced policy management framework in 2005(c) SQL policy administrator uses SQL Server Management Studio to create policies that can handle entities on the server side like the SQL Server objects(d) MS SQL Server 2008 provides a very important feature for policy based administrationI got this question in exam.The doubt is from Policy Based Management topic in portion Enterprise Data Management of SQL Server |
|
Answer» The correct choice is (B) SQL server has INTRODUCED policy MANAGEMENT framework in 2005 |
|
| 68. |
Which of the following is policy based management tip related to administration?(a) Evaluate and Implement Policies in Multiple SQL Server Instances(b) Identify SQL Server Databases Not in Full Recovery Model(c) SQL Server Policy Based Management Has Clustered Index Condition(d) None of the mentionedThe question was asked by my school teacher while I was bunking the class.This interesting question is from Policy Based Management topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct option is (a) Evaluate and Implement Policies in Multiple SQL SERVER Instances |
|
| 69. |
Which of the following is Policy-based management view?(a) sys_policies(b) syspolicy_policies(c) syspolicy(d) all of the mentionedThe question was asked by my college director while I was bunking the class.The question is from Policy Based Management topic in chapter Enterprise Data Management of SQL Server |
|
Answer» Correct choice is (B) syspolicy_policies |
|
| 70. |
Point out the correct statement related to database configuration.(a) Enable Data File Growth for all the Databases Using Policy Based Management(b) Monitor Your SQL Server Linked Server Configurations with Policy Based Management(c) Configuring Alerts for SQL Server Policy Based Management(d) None of the mentionedI got this question in final exam.Question is taken from Policy Based Management topic in division Enterprise Data Management of SQL Server |
|
Answer» Right CHOICE is (a) Enable Data File Growth for all the Databases Using POLICY Based Management |
|
| 71. |
Policy based management views are present in _________ database.(a) Master(b) Msdb(c) Tempdb(d) ModelI got this question in an online quiz.I'm obligated to ask this question of Policy Based Management in section Enterprise Data Management of SQL Server |
|
Answer» The correct CHOICE is (b) Msdb |
|
| 72. |
Users need _________ permission to create collection model object in MDS.(a) Delete(b) Create(c) Update(d) ReadThe question was asked in homework.Enquiry is from Enterprise Data Management in division Enterprise Data Management of SQL Server |
|
Answer» RIGHT answer is (c) Update Easiest explanation: Users can create collections in Master Data MANAGER if they have a minimum of Update PERMISSION to the collection MODEL object and access to the Explorer functional AREA. |
|
| 73. |
Which of the following data tools comes installed with SQL Server 2012?(a) SSAS(b) SSRS(c) DQS(d) All of the mentionedI had been asked this question in an interview for internship.I want to ask this question from Enterprise Data Management in division Enterprise Data Management of SQL Server |
|
Answer» Right OPTION is (d) All of the mentioned |
|
| 74. |
Creation ofa Derived Hierarchy requires permission to ___________(a) System Administration(b) DQS(c) syschema(d) None of the mentionedI got this question in unit test.The doubt is from Enterprise Data Management in chapter Enterprise Data Management of SQL Server |
|
Answer» The CORRECT answer is (a) System Administration |
|
| 75. |
Which of the following action cannot be performed with MDS?(a) Create entities(b) Create attributes for your entities(c) Export members for your supporting entities(d) All of the mentionedThis question was addressed to me in final exam.Query is from Enterprise Data Management topic in portion Enterprise Data Management of SQL Server |
|
Answer» CORRECT ANSWER is (C) EXPORT MEMBERS for your supporting entities Best explanation: Begin populating your master data by using the staging process. You may want to start by importing the members for your supporting entities. |
|
| 76. |
Key component that help you build an EIM solution is ____________(a) SSRS(b) SSAS(c) SSIS(d) All of the mentionedThis question was addressed to me during an internship interview.My query is from Enterprise Data Management in chapter Enterprise Data Management of SQL Server |
|
Answer» CORRECT option is (C) SSIS Explanation: SQL Server Integration Services (SSIS) is a COMPONENT of the Microsoft SQL Server database software that can be used to PERFORM a broad range of data migration TASK. |
|
| 77. |
Point out the wrong statement.(a) Spotlight is quality tool for SQL Server Enterprise(b) The BIDS paradigm for developing reports is based on the concept of distributed queries(c) GeoFlow is data management tool for SQL Server(d) All of the mentionedThis question was posed to me in unit test.This key question is from Enterprise Data Management in portion Enterprise Data Management of SQL Server |
|
Answer» RIGHT choice is (b) The BIDS paradigm for developing reports is BASED on the concept of distributed queries Explanation: The BIDS paradigm for developing reports is based on the concept of projects and solutions. |
|
| 78. |
Which is the more preferred way tool of effective data management strategy and decision making?(a) BIDS(b) SSMS(c) Excel(d) SSRSI had been asked this question by my school principal while I was bunking the class.The above asked question is from Enterprise Data Management in portion Enterprise Data Management of SQL Server |
|
Answer» Correct choice is (a) BIDS |
|
| 79. |
Which of the following SQL Server tools is used to enhance data management and governance?(a) SSIT(b) SSDT(c) OBEII(d) All of the mentionedI have been asked this question in class test.I need to ask this question from Enterprise Data Management topic in section Enterprise Data Management of SQL Server |
|
Answer» Correct ANSWER is (b) SSDT |
|
| 80. |
Point out the correct statement.(a) SSIS provides a powerful, extensible platform for integrating data from various sources(b) DQS provides a central data hub that ensures that the integrity of information and consistency of data is constant across different applications(c) MDS enables you to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, a data warehouse, and transaction processing workloads(d) None of the mentionedI got this question by my school teacher while I was bunking the class.My question is from Enterprise Data Management in section Enterprise Data Management of SQL Server |
|
Answer» Correct option is (a) SSIS provides a powerful, extensible PLATFORM for integrating data from various sources |
|
| 81. |
Which of the following tools is used for enterprise information management?(a) SSAS(b) SSIS(c) SSRS(d) All of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.This interesting question is from Enterprise Data Management in section Enterprise Data Management of SQL Server |
|
Answer» Correct choice is (d) All of the mentioned |
|