70-465 Exam Questions
164 real 70-465 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #53Design and implement database solutions for SQL Server
You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation?
FilegroupsBackup strategyDatabase administrationPhysical database design - Question #54Design and implement database solutions for SQL Server
You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?
Database snapshotsData recoveryPoint-in-time recovery - Question #55Design and implement database solutions for SQL Server
You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort. What should you recommend?
NormalizationData integrityDatabase designMissing data - Question #56Design and implement database solutions for SQL Server
You need to recommend a solution that reduces the time it takes to import the supplier data. What should you include in the recommendation?
Bulk import performanceResource GovernorPerformance tuning - Question #57Design and implement database solutions for SQL Server
You need to recommend a solution that addresses the file storage requirements. What should you include in the recommendation?
FileTableFILESTREAMLarge object storageFile system integration - Question #58Design database security solutions
You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?
Contained usersDatabase portabilityUser managementAuthentication - Question #59Design database security solutions
You need to recommend a solution that addresses the security requirement. What should you recommend?
SQL Server permissionsDENY permissionDatabase securityAccess control - Question #60Implement transactions and concurrency control in Azure SQL Database / SQL Server - specifically selecting appropriate isolation levels to balance data consistency and performance for DML operations.
Drag and Drop Question You need to recommend which statement should be used to update SalesOrder. How should you recommend completing the statement? To answer, drag the appropriate...
Transaction Isolation LevelsSNAPSHOT IsolationConcurrency ControlT-SQL DML - Question #61Design and implement database solutions for SQL Server
What should you recommend for the updates to Sales.TransactionHistory?
Storage optimizationData archivingData types - Question #62Design and implement database solutions for SQL Server
You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?
Disaster recoveryLog shippingHigh availability - Question #63Design and implement database solutions for SQL Server
You need to recommend a solution to minimize the amount of time it takes to execute USP_5. What should you include in the recommendation?
Cross-database ownership chainingStored procedure performancePerformance tuningDatabase security - Question #64Design database security solutions
You need to recommend a solution to meet the security requirements of the junior database administrators. What should you include in the recommendation?
SQL Server securityCredentialsDBA permissions - Question #65Design and implement database solutions for SQL Server
You need to recommend a change to USP_3 to ensure that the procedure continues to execute even if one of the UPDATE statements fails. Which change should you recommend?
T-SQL transactionsXACT_ABORTError handling - Question #66Design and implement database solutions for SQL Server
You need to recommend a disaster recovery solution for the Dev database. What should you include in the recommendation?
SQL Server recovery modelsBackup strategyDisaster recovery - Question #67Design and implement database solutions for SQL Server
You need to recommend a solution for the planned changes to the customer classifications. What should you recommend? (Each correct answer presents part of the solution. Choose all...
Database designData modelingSlowly changing dimensions - Question #68Design and implement database solutions for SQL Server
You need to recommend a change to USP_3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?
T-SQL transactionsXACT_ABORTAtomic operations - Question #69Design and implement database solutions for SQL Server
You need to recommend a solution for the error handling of USP_3. The solution must minimize the amount of custom code required. What should you recommend?
T-SQL error handlingTRY...CATCHStored procedures - Question #70Design and implement database solutions for SQL Server
You need to recommend a solution that meets the data recovery requirement. What should you include in the recommendation?
SQL Server backupsData recoveryDifferential backup - Question #71Design and implement database solutions for SQL Server
You need to recommend a solution to minimize the amount of time it takes to execute USP_2. What should you recommend?
T-SQL performanceTemporary tablesStored procedure optimization - Question #72Design and implement database solutions for SQL Server
You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for USP_4. What should you recommend?
T-SQL error handlingRAISERRORNested stored procedures - Question #73Design and implement database solutions for SQL Server
You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you recommend replacing Table1?
SQL Server performanceViewsQuery optimization - Question #74Design database security solutions
You need to recommend a solution to ensure that USP_4 adheres to the security requirements. What should you include in the recommendation?
SQL Server securityAuditingSQL Server Audit - Question #75Design and implement database solutions for SQL Server
You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you recommend replacing Table1?
T-SQL performanceTemporary tablesStored procedure optimization - Question #76Design and implement database solutions for SQL Server
You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?
SQL Server performanceProcessor affinityResource management - Question #77Design database security solutions
You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing...
SQL Server securityServer rolesLeast privilege - Question #78Design and implement database solutions for SQL Server
You need to recommend a solution to meet the recovery requirements for the manufacturing database. Your solution must minimize costs. What should you recommend?
SQL Server recoveryDatabase snapshotsCost optimization - Question #79Design and implement database solutions for SQL Server
You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?
SQL Server monitoringDMVsDisk usage - Question #81Design database security solutions
You need to enable users to modify data in the database tables using UPDATE operations. You need to implement a solution that meets the design requirements. What should you configu...
SQL Server securityStored proceduresEXECUTE ASLeast privilege - Question #82Design database security solutions
You need to ensure that the account used to generate reports can only connect during certain hours. What should you configure?
SQL Server securityLogon triggersTime-based access - Question #83Design and implement database solutions for SQL Server
You need to meet the design requirement for the ProductTypes table in the Product database. Which of the following would be the best solution?
Database designData integrityCHECK constraint - Question #84Design and implement database solutions for SQL Server
You need to plan the SQL Server 2012 deployment that meets the design requirements. Which of the following steps should you perform? (Choose all that apply)
SQL Server deploymentAlwaysOn Availability GroupsFailover ClusteringHigh availability - Question #85Design database security solutions
You need to recommend a solution to meet the design requirement of logging all failed authentication requests. What should you recommend?
Login auditingAuthentication loggingSQL Server security - Question #88Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. The sales and marketing departments contain a t...
Database backupMaintenance PlansBackup automationSQL Server Agent - Question #89Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring a highly-available database...
AlwaysOn Availability GroupsHigh AvailabilitySynchronous failoverWAN latency - Question #90Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You are configuring a highly-available database...
AlwaysOn Availability GroupsDisaster RecoveryAsynchronous failoverWAN latency - Question #91Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. A full backup...
Database snapshotsDeployment rollbackPoint-in-time recoverySQL Server backups - Question #92Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contai...
Transaction log managementRecovery modelsBulk importDatabase performance - Question #93Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contai...
Change Data Capture (CDC)Data auditingSQL Server monitoring - Question #94Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named CorpDB. You plan to c...
Transaction isolation levelsDirty readsREAD UNCOMMITTEDStored procedure design - Question #95Design and implement database solutions for SQL Server
You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The company has a database named Products. Tables in the Produc...
FILETABLEFILESTREAMUnstructured data storageSQL Server integration - Question #96Design database security solutions
You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. You are developing a custom CRM application named CorpCRM. The...
Password securityOne-way encryptionHashingSQL Server security - Question #97Design and implement database solutions for SQL Server
You need to ensure that a stored procedure fails if an INSERT statment within the stored procedure fails. What action should you take?
T-SQL error handlingXACT_ABORTStored procedure robustness - Question #98Design database security solutions
You need to grant access to a OLTP database regardless of the user operating the application. Which strategy should you use? Select the BEST answer.
Application rolesDatabase access controlSQL Server security - Question #99Design database security solutions
You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the data...
Contained databasesContained database usersDatabase portabilityWindows authentication - Question #100Design database security solutions
You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sal...
Database rolesPermissions managementSchema permissionsSQL Server security - Question #101Design and implement database solutions for SQL Server
You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution to ensure that all of the statements in the stored procedur...
Snapshot isolationDatabase concurrencyTransaction isolation - Question #102Design and implement database solutions for SQL Server
You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week: - Rebuild the indexes by using a new fill fact...
Database maintenanceMaintenance PlansIndex rebuildingDatabase backup automation - Question #103Design database security solutions
You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs...
Server rolesPermissionsLeast privilegeSQL Server securityT-SQL security - Question #104Design and implement database solutions for SQL Server
You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries that read data and pr...
AlwaysOn Availability GroupsReadable secondaryWorkload offloading - Question #105Design and implement database solutions for SQL Server
You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create...
Database mirroringEndpoint securityCross-domain communicationCertificates