Microsoft 70-765 Questions Answers

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the
existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT
commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during
business hours.
You need to ensure that the backup size is as small as possible.
Which backup should you perform every two hours?

A. BULK_LOGGED
B. NO_CHECKSUM
C. FULL
D. RESTART
E. CHECKSUM
F. STANDBY
G. DBO.ONLY
H. NORECOVERY
I. SIMPLE
J. SKIP
K. Transaction log
L. COPY_ONLY
M.Differential
N. CONTINUE_AFTER_ERROR

Answer: K

 https://www.microsoft.com/en-us/learning/exam-70-765.aspx

https://www.dumpscompany.com/70-765-exam-dumps

Microsoft 70-765 Questions Answers

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the
existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT
commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You need to ensure that the minimum amount of data is lost.
Which recovery model should the database use?

A. FULL
B. DBO_ONLY
C. CONTINUE_AFTER_ERROR
D. CHECKSUM
E. NO_CHECKSUM
F. SIMPLE
G. Transaction log
H. SKIP
I. RESTART
J. COPY_ONLY
K. NORECOVERY
L. BULK_LOGGED
M.Differential
N. STANDBY

Answer: A

Microsoft 70-765 Questions Answers

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the
existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT
commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during
business hours.
On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version.
You need to perform a full database backup that will be restored on the development server.
Which backup option should you use?

A. NORECOVERY
B. FULL
C. NO_CHECKSUM
D. CHECKSUM
E. Differential
F. 8ULK_LOGGED
G. STANDBY
H. RESTART
I. SKIP
J. Transaction log
K. DBO ONLY
L. COPY_ONLY
M.SIMPLE
N. CONTINUE AFTER ERROR

Answer: L

Microsoft 70-765 Question Answer

You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.
You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.

A. Restart the SQL Server Agent Service.
B. Disable snapshot isolation.
C. Restart the SQL Server Service.
D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
E. Add the CONTOSO\SQLService account to the Server Operators fixed server role.
F. Enable snapshot isolation.

Answer: CD


You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.
What should you do?

A. Run the New SQL Server stand-alone installation Wizard on Node C.
B. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
C. Use Node B to install SQL Server on Node C.
D. Use Node A to install SQL Server on Node C.

Answer: B

Microsoft 70-765 Question Answer

You administer a Microsoft SQL Server 2012 database.
Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error.
You need to identify the root cause of the issue by retrieving the error message.
What should you do?

A. Create an Extended Events session by using the sqlserver.error_reported event.
B. Create a SQL Profiler session to capture all ErrorLog and EventLog events.
C. Flag all stored procedures for recompilation by using sp_recompile.
D. Execute sp_who.

Answer: A


You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application.
Users report abnormally long wait times when they submit data into the application.
You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

A. use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.
B. Use sp_configure to set a value for blocked process threshold. Create an extended event session.
C. Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.
D. Run the sp_who command from a query window.
E. Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.

Answer: E

Updated With Currency And Color Recognition, Seeing AI Is Available In 35 Countries

Since we made Seeing AI available for the first time, there have been 100,000 downloads of the application and it has helped users with more than 3 million tasks. We have never been more humble with your comments and we recommend you do more! When we launched for the first time, we launched with features such as the ability to listen to what is a product through the audible location of the bar code, the description of images, text and faces of friends and family as they appear. Today, we are pleased to announce new features for the application that will be based on these first results, provide new user experiences and allow us to continue learning and innovating. These new features, such as currency, handwriting and color recognition, as well as light detection, are now available in the application in 35 countries, including the European Union.

Some of the new features now available in Seeing AI include:

•     Color recognition: getting dressed in the morning is easier with this new feature, which describes the color of the objects, like the clothes in your closet.

•     Currency Recognition: Seeing that AI can now recognize the currency of US dollars, Canadian dollars, pounds sterling and euros. Seeing how much change is in your pocket or leaving a coupon in cash at a restaurant is much easier.
•     Musical light detector: the application alerts you with a corresponding audible tone when you point the phone's camera at the light of the surroundings. A convenient new tool so you do not have to touch the hot bulbs to know that the light is off or that the battery LED is on.
•     Handwriting recognition: By expanding the ability of the application to read printed text, such as menus or signs, the recently improved ability to read handwriting means that you can read personal notes on a greeting card, as well as printed text not usually readable by optical character recognition.
•     Document reading: Seeing that AI can read the document aloud without a voice-over, with synchronized highlighting of words. In addition, it includes the ability to change the size of the text in the document's channel.
•     Ability to choose voices and speed: personalization is the key, and when you are not using VoiceOver, this feature allows you to choose between the voice used and the speed at which you speak.

With each of these new functions, we make sure to protect personal data while guaranteeing that technology works effectively and provides users with the best experiences with our products. If you have questions, the Microsoft Privacy Statement explains how Microsoft collects, stores and uses personal information.

We continue to hear you how Seeing AI brings value to your life. It is more than humiliating. Cameron Roles, a university professor at the Law School of the Australian National University, believes that there has never been a better time in history to be a blind person.

"I love seeing IA. If my children give me a note from school or if I take a book, I can use Seeing AI to quickly capture that text and just give me a brief snapshot of what's in the document," Roles said. The important ability of the application has to read text and handwriting. "I can be quickly aware."

"For me, I think we are reaching a really exciting time," said Roles. "The growth in artificial intelligence, augmented reality, cars without driver ... I feel it is a great moment for all of us in society."

"Technology can be an enabler of good and an enabler for people to reduce the world, for the world to come closer and for people to achieve much more than they could without it," said Roles.

We are pleased to share these characteristics and look forward to hearing from you that Seeing AI is making your world more inclusive. It is available in the Apple App Store in 35 countries and when a new version is released, the next time you start the application you will be shown the list of new features.

Microsoft 70-765 Question Answer

Note: This questions is part of a series of questions that use the same or similar answer
choices. An answer choice may be correct for more than one question in the series. Each
question is independent of the other questions in this series. Information and details
provided in a question apply only to that question.
Your company has several Microsoft Azure SQL Database instances.
Data encryption should be allowed to be implemented by the client applications that access
the data. Encryption keys should not be made available to the database engine.
You need to configure the database.
What should you implement?

A. transport-level encryption
B. cell-level encryption
C. Transparent Data Encryption
D. Always Encrypted
E. Encrypting FileSystem
F. BitLocker
G. dynamic data masking

Answer: A



Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains a unique solution. Determine whether the solution meets
stated goals.
You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local
variables.
Solution: You enable the LEGACY_CARDINALITY_ESTIMATION option for the databases.
Does the solution meet the goal?

A. Yes
B. No

Answer: B