70-465 Exam Questions
164 real 70-465 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #106Design and implement database solutions for SQL Server
You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.
FILETABLEFILESTREAMDatabase configuration - Question #107Design and implement database solutions for SQL Server
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The Sales department uses a database named S...
Table partitioningPerformance optimizationData management - Question #108Design database security solutions
You work as a Database Administrator (DBA) at ABC.com. You are in the process of deploying new servers running SQL Server 2012. You need to deploy a SQL Server 2012 server to host...
Transparent Data Encryption (TDE)Data encryptionDatabase security - Question #109Design and implement database solutions for Azure SQL Database
You work as a Database Administrator (DBA) for a company named ABC.com. The company has a Windows Azure subscription. The company uses a cloud based SQL Server environment hosted o...
Data encryptionSQL Azure securitySensitive data protection - Question #110Design 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. A server named ABC-SQL1 hosts multiple database...
AlwaysOn Availability GroupsHigh availabilitySQL Server 2012 - Question #111Design 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. Computer users use custom applications that sto...
SQL Server AgentAlertsJobsEvent monitoring - Question #112Design database security solutions
You need to move a database in between servers. You need to guarantee database users will be able to login in the database with a minimum of management effort. Select the BEST answ...
Database usersLogin migrationSecurity management - Question #113Design and implement database solutions for SQL Server
You need to validate rows before they are added to a table every time a row is added using a user-defined function. What should you use? More than one answer may achieve the goal....
CHECK constraintData validationData integrity - Question #114Design and implement database solutions for SQL Server
You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can comp...
Transaction log backupLog Sequence Number (LSN)Log full - Question #115Design and implement database solutions for Azure SQL Database
You use SQL Azure to store data used by an e-commerce application. You develop a stored procedure named sp1. Sp1 is used to read and change the price of all the products sold on th...
Transaction isolation levelsSQL Azure concurrencySerializable isolation - Question #116Design and implement database objects - specifically selecting appropriate SQL Server storage technologies (FileTable, FileStream, Filegroups) based on requirements for file accessibility, folder hierarchy, UNC paths, and granular backup scheduling.
Drag and Drop Question You are designing a database for a university. The database will contain two tables named Classes and StudentGrades that have the following specifications: -...
FileTableFilegroup BackupSQL Server StorageDatabase Design - Question #117Design and implement database solutions for SQL Server
You use SQL Server 2014 to maintain the data used by applications at your company. You want to execute two statements. You need to guarantee that either both statements succeed, or...
TransactionsAtomicityT-SQL - Question #118Design and implement database solutions for Azure SQL Database
Your company has a SQL Azure subscription. You implement a database named Database1. Database1 has two tables named Table1 and Table2. You create a stored procedure named sp1. Sp1...
Stored procedure permissionsSQL Azure securityEXECUTE permission - Question #119Design and implement database solutions for SQL Server
You deploy a SQL Server instance named SQLProd that uses SQL Server 2014. You need to recommend a solution to monitor the transactions that are running currently against SQLProd. T...
Dynamic Management Views (DMV)SQL Server monitoringTransaction monitoring - Question #120Design database security solutions
Your network contains an Active Directory domain that has two groups named Group1 and Group2. The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server...
Row-level securityUser-defined viewsData access control - Question #121Design and implement database solutions for SQL Server
You are the new database administrator for a SQL Server 2014 instance. You conduct an assessment on the instance and determine that the auto create statistics setting on the databa...
Statistics monitoringExtended EventsQuery performance - Question #122Design database security solutions
You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in D...
Application rolesCross-database accessStored procedure security - Question #123Design and implement database solutions for SQL Server
You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. You need to recommend a method to allocate processors t...
Processor affinityResource allocationSQL Server instance configuration - Question #124Design and implement database solutions for SQL Server
You have two SQL Server 2014 instances named SQLDev and SQLProd. You plan to create a new database on SQLProd that will use SQL Server Authentication. You need to ensure that when...
Contained databasesSQL Server Authenticationdatabase migration - Question #125Design and implement database solutions for SQL Server
You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing...
Query performance tuningblocked processesSQL Server alerts - Question #126Design and implement database solutions for SQL Server
You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to identify the isolation level used by the query when a deadlock oc...
Deadlocksisolation levelsdynamic management viewsSQL Server Profiler - Question #127Design and implement database solutions for SQL Server
You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing i...
SQL Server monitoringdynamic management viewsactive connectionsblocked sessions - Question #128Design and implement database solutions for Azure SQL Database
You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows. You need to recommend a repeatable method to migrate the database to SQL Azure. Which method...
Database migrationSQL Server to Azure SQL DatabaseSSISdata-tier application - Question #129Design and implement database solutions for SQL Server
You have a SQL Server 2014 database named DB1. You plan to import a large number of records from a SQL Azure database to DB1. You need to recommend a solution to minimize the amoun...
Transaction log managementrecovery modelsbulk operationsdata import - Question #130Design and implement database solutions for SQL Server
You have a server named Server1 that has 2 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple databases. You need to...
Resource managementResource GovernorCPU allocationmulti-instance deployment - Question #131Design and implement database solutions for SQL Server
You have a SQL Server 2014 environment That includes four servers. The servers are configured as shown in the following table. You plan to configure Policy-Based Management to enfo...
Policy-Based ManagementCentral Management ServerSQL Server configurationpassword policies - Question #132Design and implement database solutions for SQL Server
You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differen...
Disaster recoverybackup to AzureSQL Server backupsRPO/RTO - Question #133Design and implement a data warehousing solution
You need to recommend a backup process for data warehouse database. The solution must meet the following requirements: - Ensure that if a hardware failure occurs, you can bring the...
SQL Server BackupRecovery ModelsTransaction Log ManagementData Warehouse Strategy - Question #134Design and implement database objects - specifically optimizing column storage and retrieval performance in Azure SQL Database
You plan to deploy a database to SQL Azure. You must create two tables named Table 1 and Table 2 that will have the following specifications: - Table1 will contain a date column na...
SQL AzureSparse ColumnsComputed ColumnsTable Design Optimization - Question #135Design and implement database solutions for SQL Server
You use SQL Server 2014. You create a table within a database by using the following DDL: The following table illustrates a representative sample of data: The system is expected to...
SPARSE columnsSQL Server storage optimizationDatabase design best practicesData type considerations - Question #136Implementing Database Objects - Creating and managing stored procedures, understanding the differences between stored procedures and functions in SQL Server 2014.
You use SQL Server 2014. You need to create a single object that inserts a provided value into Table1, and then returns a count of the records in Table1. Develop the solution by se...
Stored ProceduresOUTPUT ParametersT-SQLSQL Server Objects - Question #137Design and Implement High Availability Solutions in SQL Server
You plan to install two SQL Server 2014 environments named Environment1 and Environment2. Your company identifies the following availability requirements for each environment: - En...
Database MirroringAlways On Availability GroupsHigh AvailabilitySQL Server 2014 - Question #139Implementing SQL Server High Availability and Disaster Recovery Solutions - specifically understanding the minimum infrastructure requirements for mirroring (manual failover) versus AlwaysOn Availability Groups (automatic failover) to ensure data availability during server failures.
Drag and Drop Question You plan to install two SQL Server 2012 environments named Environment1 and Environment2. Your company identifies the following availability requirements for...
Database MirroringAlwaysOn Availability GroupsHigh AvailabilitySQL Server 2012 - Question #140Infrastructure and Network Architecture - assigning appropriate server functions based on organizational and technical requirements, commonly tested in certifications such as CompTIA Server+, Microsoft Azure Administrator (AZ-104), or similar infrastructure-focused exams.
Drag and Drop Question You need to distribute functionality across the three servers. Which function should you assign to each server? To answer, drag the appropriate functions to...
Server RolesNetwork ArchitectureWorkload DistributionInfrastructure Design - Question #141Design and implement database solutions for SQL Server
You are designing your maintenance plan. Which command should you use only during the monthly maintenance window?
Index maintenanceALTER INDEX REBUILDonline operationsmaintenance window - Question #142Design and implement database solutions for SQL Server
You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort. Which code should you use?
T-SQLreporting queriesquery optimizationviews/stored procedures - Question #143Design database security solutions
You need to configure security on the Product table for customer support representatives. Which two actions should you perform? Each correct answer presents part of the solution. C...
Database securityviewsGRANT permissionsrole-based access controlprinciple of least privilege - Question #144Design and implement database solutions for SQL Server
You need to implement a backup strategy to support the requirements. Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
Azure storage backupSQL Server backupBACKUP TO URLcredentials - Question #145Design and implement database solutions for SQL Server
You need to implement changes to the system to reduce contention and improve performance of the SalesOrderDetail table. Which three actions should you perform? Each correct answer...
transaction isolation levelsREAD_COMMITTED_SNAPSHOTconcurrencyperformance tuning - Question #146Implement High Availability and Disaster Recovery Solutions - specifically configuring SQL Server Always On Availability Groups including endpoint creation, AG definition, and secondary replica joining procedures.
Drag and Drop Question The business requires a satellite office to have a local copy of the data to report against. You want to implement a solution to support the requirements. Yo...
Always On Availability GroupsHigh AvailabilitySQL Server EndpointsDatabase Replication - Question #147Design and implement database solutions for SQL Server
You need to change the ProdDB database. Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.
In-Memory OLTPmemory-optimized tablesdatabase configurationperformance tuning - Question #148Implement database maintenance plans and automate administrative tasks, including managing statistics for query optimizer performance in SQL Server
Drag and Drop Question You need to create a job to automate some database maintenance tasks. Which code fragment should you use in each location in the command to complete one of t...
UPDATE STATISTICSSQL Server Database MaintenanceQuery OptimizationT-SQL Jobs - Question #149Design and implement database solutions for SQL Server
Drag and Drop Question You need to create the CustomerAccess table to support the reporting and performance requirements. Develop the solution by selecting and arranging the requir...
SQL ServerDDLFilegroupsTable Creation - Question #150Design database solutions for SQL Server on Microsoft Azure virtual machines
You need to recommend a solution to back up DB1. What should you include in the recommendation?
Azure Blob Storagedatabase backupAzure storage types - Question #151Design database solutions for SQL Server on Microsoft Azure virtual machines
What should you create in Azure to support the creation of the backups for DB1?
Azure storage accountdatabase backupAzure infrastructure - Question #152Design and implement database solutions for SQL Server
Which feature should you enable and configure so session requests addressed to a specific instance can be allocated to different processor resources based on session request proper...
processor affinityresource allocationperformance tuningSQL Server configuration - Question #153Implementing Programmability Objects in SQL Server / Designing and Implementing Stored Procedures using appropriate SQL Server technologies
You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements: - Procedure1 must take a parameter that ensures that multiple rows...
SQL Server Stored ProceduresTable-Valued ParametersCLR IntegrationT-SQL Design - Question #154Design database security solutions
You are using dynamic management views to monitor an SQL Server server named SQL1. A database administrator named Dba1 must monitor the health of SQL1. You need to ensure that Dba1...
Dynamic Management Views (DMVs)VIEW SERVER STATESQL Server permissionsleast privilege - Question #155Design and implement a data warehousing solution
You have a customer who has several SQL Server 2012 database servers. You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes. The cust...
columnstore indexesSQL Server 2014data warehousingclustered columnstore indexes - Question #156Design database security solutions
Drag and Drop Question You need to assign security to dev_role1. How should you complete the code? To answer, drag the appropriate elements to the correct locations. Each element m...
SQL Server SecuritySchema ManagementRole-Based SecurityPermissions Management